| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running macro on file open
Thank you very much. It was really helpful.
"Dave Peterson" wrote: You could use a macro: Option Explicit Sub Auto_Open() application.goto thisworkbook.worksheets("sheet9999").range("a1"), _ scroll:=true End Sub Change the sheet name and cell address to what you 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 excelnerd wrote: When I open a particular excel file, I want to always have the cursor on a specific worksheet. That is, I want the file to open in a particular worksheet. How can I do that? Many thanks in advance. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to run on file open | Excel Discussion (Misc queries) | |||
| Open File within a macro | Excel Discussion (Misc queries) | |||
| How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
| Excel is running virus scan each time I open a file can I turnoff | Setting up and Configuration of Excel | |||
| How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
Threaded Mode
