ScrollArea values help Excel 2007

[Clyde38]

When I set the ScrollArea in the properties for a worksheet, all is well. When I save the workbook and then reopen, the ScrollArea properties is blank and scrolling is not locked. The worksheet is protected. How do I retain the ScrollArea setting?

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[Clyde38]

This works, but you have to make a selection before the scroll area is locked.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.ScrollArea = "E6:R38"
End Sub


Is there a way to have this active when the workbook is opened?


[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[brengine]

In the Workbook Module, Paste this code:

Private Sub Workbook_Open()
    Range("E6:R38").Select
    Me.ScrollArea = "E6:R38"
End Sub

 

[brengine]

Make that the "ThisWorkbook" Module...

 

[Clyde38]

brengine,
Thanks, I get an error (see attached) "Method or data member not found".


[link

http://www.linkedin.com/in/clydehancock

]

[/url]