ScrollArea values help Excel 2007
ScrollArea values help Excel 2007
(OP)
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
ScrollArea values help Excel 2007
|
RE: ScrollArea values help Excel 2007
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?
RE: ScrollArea values help Excel 2007
CODE
Range("E6:R38").Select
Me.ScrollArea = "E6:R38"
End Sub
RE: ScrollArea values help Excel 2007
RE: ScrollArea values help Excel 2007
Thanks, I get an error (see attached) "Method or data member not found".