Warning message

[Zoidy]

I want to be able to put a "Warning Message" that the user presses "ok" to once read when opening up an excel document.

Basically, open excel

Warning message appears not to touch certain data

Press Ok

Use the sheet

Any idea's what's the best way to manage this?
Macro maybe?

Thanks

Zoid

 

[agihcam]

Hi -
Hit Alt + F11, from VBA Project, double click thisworkbook and paste this code to the module. save the file and close then open again.

Private Sub Workbook_Open()
MsgBox "This is a test message, click OK button to proceed", vbInformation + vbOKOnly, "Welcome Message"
End Sub

 

[sykes]

Hi Zoid

Easiest way is to put a simple bit of code into the workbook's open event:

1. Use Alt + F11 to bring up the VBA window.
2. Find the project explorer if not already open, and open it.
3. Find your project in the explorer.
4. Right-click "This workbook" and select "View Code"
5. In the left hand dropdown select "workbook", and the righthand one, "open"
6. You should see this:

Private Sub Workbook_Open()

End Sub

7. Copy and paste this in:
Msgbox "Please don't touch the data marked leave off!!"
8. Whole lot should look thus:

Private Sub Workbook_Open()
MsgBox "Please don't touch the data marked leave off!!"
End Sub

9.Save the workbook
10. Close & re-open.

Change the text in the messagebox to suit your needs.
In the VBA window go to help (for VBA help, not Excel help), and look up msgbox. It will give you a lot more options apart from the basic message I've discussed here.

All the best.

 

[Zoidy]

Thanks Guys,
Fast Response!

I'll give this a wizz