Z
ziakinp
How do I set up workbook to open on specific worksheet every time?
D
Dave Peterson
You can use a macro in that workbook that runs each time you open that workbook
(well, if macros are enabled).
This will go into a General module:
Option Explicit
sub auto_open
application.goto worksheets("sheet99").range("a1"), scroll:=true
end sub
(Change the sheet name and the range address to what you really want.)
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
(well, if macros are enabled).
This will go into a General module:
Option Explicit
sub auto_open
application.goto worksheets("sheet99").range("a1"), scroll:=true
end sub
(Change the sheet name and the range address to what you really want.)
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Z
ziakinp
Thanks I will give it try!