hey
can you tell me how to produce an autostart macro, so when i open the excel file it will go straight to a specific worksheet, or is there another easier way of doing this ?
thanks
foad
hey
can you tell me how to produce an autostart macro, so when i open the excel file it will go straight to a specific worksheet, or is there another easier way of doing this ?
thanks
foad
Last edited by foad; 03-12-2009 at 04:36 PM.
Try an Event macro. Code would go in ThisWorkbook module
http://www.contextures.com/xlvba01.html#Workbook
VBA Noob![]()
Private Sub Workbook_Open() Application.Goto Reference:=Sheets("Sheet1").Range("A1"), scroll:=True End Sub
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks for your help VBA n00b
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks