Can I add a pop-up message that will show when a workbook opens

C

Cruisin Lo

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

CLR

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
 
T

Tonso

that is a great macro! i scan these topics often and pick up some good
ideas and techniques. thanks...
 
C

CLR

Glad it was helpful for you..........thanks for the compliment.

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

You have some suggestions that use VBA to achieve your results.

Just be aware that if users disable macros, your code will not work.

You may wish to add further code to trap for that.

i.e. when the workbook is closed, a sheet saying "If you have disabled macros,
this workbook is useless"

You xlveryhidden all the sheets but that one.

If users open the workbook with macros disabled, this is all they will see.

If macros are enabled, your Workbook_Open code will show the NOTICE sheet.


Gord Dibben MS Excel MVP
 
Top