StartUp Macros

Mar 8th, 2002, 07:51 AM

How do you set a macro to run automatically to initialize a spreadsheet. I want a spreadsheet to start the same everytime regarless of what was changed or entered.

Mar 8th, 2002, 02:11 PM

Figured out my own issue.

Right click the "little" spreadsheet symbol to the left of the File menu option and "View Code"

In the WorkBook code sheet, select the "Open" sun or type Private Sub Workbook_Open()

Then type
Application.Run "WorkBookName.xls!MacroName"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 07:51 AM	#1
Guest Posts: n/a	How do you set a macro to run automatically to initialize a spreadsheet. I want a spreadsheet to start the same everytime regarless of what was changed or entered.

Mar 8th, 2002, 02:11 PM	#2
Guest Posts: n/a	Figured out my own issue. Right click the "little" spreadsheet symbol to the left of the File menu option and "View Code" In the WorkBook code sheet, select the "Open" sun or type Private Sub Workbook_Open() Then type Application.Run "WorkBookName.xls!MacroName"