Start-up Macro

[d23]

All,

I need to run a text disclaimer on start-up. Can I make a macro run when a file opens that would display text only? What I am looking for is a command similar to \0 in Lotus.

Thanks

D23

 

[MintJulep]

autoopen()

 

[francesca]

If you mean for Excel, then you want an event-macro. The one you're looking for is "workbook open."

 

[d23]

MintJulep and francesca,

Thank you for your replies!!!

With your recommendations I was able to dig a little deeper and found the “Workbook_Open()" function in VBA. This does what I need. I am opening the file on a new sheet with my disclaimer and have included a macro button that moves to the data input sheet.

Once again thank you for your help!

D23