Force excel to open on a specific sheet
Is there a way to force excel to open on a specific sheet?
I have 4 worksheets within the workbook, but need it to always open on a certain one. |
Force excel to open on a specific sheet
On Nov 16, 9:32 am, harwookf
wrote: Is there a way to force excel to open on a specific sheet? I have 4 worksheets within the workbook, but need it to always open on a certain one. When you save the document the last save you make is where the document will open next time Brandon |
Force excel to open on a specific sheet
I guess if you are on the sheet you want to open, just save the workbook and
close it Next time when you open, you should see the same sheet. Dont know if there is an easier way of doing this. "harwookf" wrote in message ... Is there a way to force excel to open on a specific sheet? I have 4 worksheets within the workbook, but need it to always open on a certain one. |
Force excel to open on a specific sheet
You could use a macro:
This goes in a General module--not under ThisWorkbook and not behind a worksheet: Option Explicit Sub Auto_Open() application.goto thisworkbook.worksheets("sheetnamehere").range("a1 "), _ scroll:=true End sub Change the sheetnamehere 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 harwookf wrote: Is there a way to force excel to open on a specific sheet? I have 4 worksheets within the workbook, but need it to always open on a certain one. -- Dave Peterson |
Force excel to open on a specific sheet
This works if I am the only one using the worksheet, but not when you have to
rely on others. Am going to try the macro given by Dave Peterson, but thanks for your response. Cheers "Brandon G." wrote: On Nov 16, 9:32 am, harwookf wrote: Is there a way to force excel to open on a specific sheet? I have 4 worksheets within the workbook, but need it to always open on a certain one. When you save the document the last save you make is where the document will open next time Brandon |
Force excel to open on a specific sheet
Many thanks for your help on this, it works a treat.
Cheers "Dave Peterson" wrote: You could use a macro: This goes in a General module--not under ThisWorkbook and not behind a worksheet: Option Explicit Sub Auto_Open() application.goto thisworkbook.worksheets("sheetnamehere").range("a1 "), _ scroll:=true End sub Change the sheetnamehere 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 harwookf wrote: Is there a way to force excel to open on a specific sheet? I have 4 worksheets within the workbook, but need it to always open on a certain one. -- Dave Peterson |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com