how to get a macro to run when the file opens

[Mary]

Hi,

Anyone know if this this possible?

Thanks

Mary

 

[Anne Troy]

Name the macro "Private Sub Workbook_Open()" and place it under ThisWorkbook
in the Visual Basic editor. Save and close the workbook, reopen, and the
macro should run.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Kris]

Hello Mary,

Name your macro Auto_Open()

Example:

Sub Auto_Open()
'your macro code
End sub

Sincerely,

Kris

 

[Tom Ogilvy]

Look at Chip Pearson's page on Events

http://www.cpearson.com/excel/events.htm

You want the workbook_open event.

 

[Guest]

right click the excel sheet next to the menu option 'File'
click 'view code'
right your code here and it runs on open.