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

On Sat, 26 Nov 2005 12:16:06 -0800, "Rony"
wrote:

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