Message that opens when file is opened
 

Hi - I'd like to create a message (on a form, I guess) that automatically is
opened as soon as a specific file is opened. I was hoping someone could
provide me with suggestions on how to do this or even the code they think
would be needed to do this.

Thanks,

Robert

Message that opens when file is opened
 

You can use a procedure named Auto_open in a general module:

Option Explicit
Sub Auto_Open()
msgbox "Hi from this here workbook!"
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Linking to specific cells in pivot table wrote:

Hi - I'd like to create a message (on a form, I guess) that automatically is
opened as soon as a specific file is opened. I was hoping someone could
provide me with suggestions on how to do this or even the code they think
would be needed to do this.

Thanks,

Robert

--

Dave Peterson