I have an excel workbook with lots of different sheets, is it possible for Excel to load up sheet 1 everytime when i start excel and not from the last sheet that i saved work on?
I have an excel workbook with lots of different sheets, is it possible for Excel to load up sheet 1 everytime when i start excel and not from the last sheet that i saved work on?
LEEP2008,
I have two variations on your request to activate a specific worksheet when you open your workbook (no matter what worksheet was active the last time you saved the workbook).
1. Activate worksheet name "Sheet1":
Please Login or Register to view this content.
2. Activate the first worksheet in your workbook, not the name of the worksheet (the way your tabs are in order from left to right):
Please Login or Register to view this content.
Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).
1. Copy the above code of your choice, by highlighting the macro code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. And, paste the copied code into VBAProject, Microsoft Excel Objects, ThisWorkbook (on the right pane) by pressing the keys CTRL + V
5. Press the keys ALT+Q to exit the Editor, and return to Excel
Then save and close the workbook with the active sheet not the sheet that you want to be active upon opening your workbook.
Then open the workbook again.
Last edited by stanleydgromjr; 09-23-2009 at 03:31 PM.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks that works a treat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks