how to get a macro to run when the file opens
 

Hi,

Anyone know if this this possible?

Thanks

Mary

how to get a macro to run when the file opens
 

Hello Mary,

Name your macro Auto_Open()

Example:

Sub Auto_Open()
'your macro code
End sub

Sincerely,

Kris

-----Original Message-----
Hi,

Anyone know if this this possible?

Thanks

Mary
.

how to get a macro to run when the file opens
 

Look at Chip Pearson's page on Events

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

You want the workbook_open event.

--
Regards,
Tom Ogilvy


"Mary" wrote in message
...
Hi,

Anyone know if this this possible?

Thanks

Mary

how to get a macro to run when the file opens
 

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


-----Original Message-----
Hi,

Anyone know if this this possible?

Thanks

Mary
.