Running macro when starting worksheet

[Guest]

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

 

[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)

Is there a way when you open a Excel Spreadsheet to automatically run

before any manipulation of the file happens?