Tabbing Question....

[Joann]

I named this function TheRng5. There is only one worksheet in this file.
When this file or sheet since it is the only one is opened, I want this range
to automatically be selected so that i don't have to hit the F5 key in order
to enable it.

Please help....thanks!
Joann

 

[Mike H]

Hi,

I'm confused if there's only 1 worksheet in this file then under which
circumstances do you want to goto the named range? The only one i can think
of is when the workbook is opened so maybe this

Private Sub Workbook_Open()
Application.Goto "TheRng5"
End Sub

Mike