make a macro run automatically

[jimmywanna]

I would like to know if anyone could tell me if it is possible for a macro to run as soon as a workbook is opened.
I know how to record and fiddle with macro's a little bit but don't know a whole lot about VBA script.
any help would be appreciated.

thanks in advance.

 

[DonkeyOte]

just name the macro Sub AUTO_OPEN()

and it will do just that.

 

[Richie(UK)]

... or place a call to the macro from within the Workbook_Open event of the ThisWorkbook object for the workbook concerned.

This is the recommended way of performing this action for versions of Excel after '97. See Chip Perason's site here : http://cpearson.com/excel/events.htm

HTH

 

[DonkeyOte]

Richie - I stand corrected - I always forget about that! Still learning new tricks as the days go by...

Thanks

 

[Richie(UK)]

lasw10:

You and me both mate! :wink: