Is there a marco that i can use to maximize the sheet upon opening?
Is there a marco that i can use to maximize the sheet upon opening?
Did you try recording one?
Entia non sunt multiplicanda sine necessitate
in a macro?
Yes, using the macro recorder.
Hello krazygmtrk,
Add this line of code to your workbook's Workbook_Open() event handler.
How to Save a Worksheet Event MacroPlease Login or Register to view this content.
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks