Running macro when starting worksheet

S

surveyorinva

Is there a way when you open a Excel Spreadsheet to automatically run before any manipulation of the file happens?
Any help would be great.

Thanks.
C.Fillmore
 
B

Bob Phillips

Two ways,

Create a macro named Auto_Open

or

add the code to the Workbook_Open event in the ThisWorkbook code modeul.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

surveyorinva said:
Is there a way when you open a Excel Spreadsheet to automatically run
Click to expand...
before any manipulation of the file happens?
 
Top