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

THis macro put in the Workbook module will do it, but requires that macros be
enabled..........

Private Sub Workbook_Open()
MsgBox "NOTICE: Information in this file is for OFFICIAL USE ONLY"
End Sub

You might do as well by just making the first Sheet being only the NOTICE,
and saving the file with that sheet open.

Vaya con Dios,
Chuck, CABGx3



"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?