Excel Open Command (Excel 2000)

Topic

New Reply

In Excel 2000: If I want something to control what happens when I open a specific workbook, what Excel command would I modify?

Reply | Quote

Replies

The Workbook Open Event. In the VBE go to the “ThisWorkbook” Object. At the top of the code window, select WorkBook from the Object dropdown; all the Events are listed in the Procedure dropdown to the right of the Object dropdown. In a default installation, selecting the Workbook Object immediately creates an empty Workbook_Open() event for you.

You can also use an Auto_Open macro.

Reply | Quote

Hi Girl Friday,

Just in case this is related to your other post about not letting someone copy/modify a worksheet, bear in mind that a macro-based solution is easily defeated by holding down the shft key while the workbook loads, or disabling the macro at the macro warning prompt.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote