Malissa1578
New Member
- Joined
- Mar 14, 2013
- Messages
- 10
I am going to bang my head against my keyboard soon... 
This is what I have and I have tried everything I can think of to make it work.
Activate module, dim, blah blah blah... I have read everything possible I can find and nothing is making it work.
Private Sub Workbook_Open()
Sheets("Sprinkler Projects").ScrollArea = "A1:AJ184"
End Sub
It is a project tracker workbook, it is going to have multiple tabs (I have two right now Sprinkler Projects and Sheet1) when finished and I want to set a scroll area for each one when finished. Workbook name is Sprinkler Ti Projects if that has any bearing on it.
The above tab is finished and the scroll area limits are not working.
I can go in and set them for the one edit session and when trying to make it permanent it is just not doing anything. It is saved as a macro enabled workbook.
It is probably something simple, but seriously... I need help.

This is what I have and I have tried everything I can think of to make it work.
Activate module, dim, blah blah blah... I have read everything possible I can find and nothing is making it work.
Private Sub Workbook_Open()
Sheets("Sprinkler Projects").ScrollArea = "A1:AJ184"
End Sub
It is a project tracker workbook, it is going to have multiple tabs (I have two right now Sprinkler Projects and Sheet1) when finished and I want to set a scroll area for each one when finished. Workbook name is Sprinkler Ti Projects if that has any bearing on it.
The above tab is finished and the scroll area limits are not working.
I can go in and set them for the one edit session and when trying to make it permanent it is just not doing anything. It is saved as a macro enabled workbook.

It is probably something simple, but seriously... I need help.