I want a dialog box when opened

S

SFC Traver

I want a dialog box to appear when the excel file is opened. It would contain
a warning of "protected" information and all the user would have to do is
click "OK' and then the spreadsheet would open. How do I do this?
 
J

Jarek Kujawa

press Alt+F11
in ThisWorkbook module insert the following

Private Sub Workbook_Open()
MsgBox "Protected information." & vbcrlf & vbcrlf & "Click OK to
continue"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

the dialog box prompt is not automatically activated when opening 1
Excel's Dialog Box 1
Save changes? 7
.dat file extension 3
How do I display a dialog box that pops up when you first open exc 4
Dialog boxes 5
How to Stop the Update Dialog from Appearing? 3
Macros not displaying in Run Macro dialog box 1

Top