Scroll Area _Named Range in worksheet

R

Rony

Hi
I have named range in my worksheet "INVME" in sheet1 replaced as "Master",
now I want to control thr user to move within the named range. How can i
control this in VBA.

Thanks in advance
 
G

Gord Dibben

Rony

Private Sub Workbook_Open()
With Sheets("Day")
..ScrollArea = "invme"
End With
End Sub

Or use worksheet.activate code in the worksheet


Gord Dibben Excel MVP
 
Top