View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham
 
Posts: n/a
Default Can I add a pop-up message that will show when a workbook opens

Put the messagebox into the Workbook_Open event handler

Code would be something like:

MsgBox"This Workbook Contains Work"

You can find detailed instructions on how to put code into the workbook
event on this page: http://www.jlathamsite.com/Teach/WorkbookCode.htm

"Cruisin Lo" wrote:

Is there a way to add a 'pop-up' message, whereas when a file is opened, it
will display a message warning the user the file contains 'Official Use Only'
information?