Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set defaut worksheet visible on opening workbook?
by default excel opens a workbook with the wosksheet that was visible the
last time the file was saved. How do you set a workbook to open at a default worksheet, say where there are a list of instructions for the user? |
#2
|
|||
|
|||
How do I set defaut worksheet visible on opening workbook?
You can use a macro:
Option Explicit sub auto_open() application.goto worksheets("Instructions").Range("a1"),scroll:=tru e end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm bennyob wrote: by default excel opens a workbook with the wosksheet that was visible the last time the file was saved. How do you set a workbook to open at a default worksheet, say where there are a list of instructions for the user? -- Dave Peterson |
#3
|
|||
|
|||
How do I set defaut worksheet visible on opening workbook?
Thanks Dave!
"Dave Peterson" wrote: You can use a macro: Option Explicit sub auto_open() application.goto worksheets("Instructions").Range("a1"),scroll:=tru e end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm bennyob wrote: by default excel opens a workbook with the wosksheet that was visible the last time the file was saved. How do you set a workbook to open at a default worksheet, say where there are a list of instructions for the user? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tried using SUBTOTAL function (XL XP) and it doesn't seem to work | New Users to Excel | |||
Running a macro for all visible worksheets in a workbook | Excel Discussion (Misc queries) | |||
worksheet ? of ?? in workbook | Excel Discussion (Misc queries) | |||
Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) | |||
I can't get a worksheet to copy onto the workbook | Excel Worksheet Functions |