| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want a dialog box when opened
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want a dialog box when opened
press Alt+F11
in ThisWorkbook module insert the following Private Sub Workbook_Open() MsgBox "Protected information." & vbcrlf & vbcrlf & "Click OK to continue" End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When was file last opened? | Excel Worksheet Functions | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| how to log all files opened on my pc? | Excel Discussion (Misc queries) | |||
| Incrementing by 1 when doc is opened | Excel Worksheet Functions | |||
| To fix a sheet in MS Office to be opened first always | Excel Worksheet Functions | |||
Linear Mode
