Message when opening a sheet

  • Thread starter Thread starter Jim Lavery
  • Start date Start date
J

Jim Lavery

How do I get excel to produce a message whenever a particular worksheet in a
file is accessed?
 
Right click the worksheet, view code and paste this in

Private Sub Worksheet_Activate()
MsgBox "Please read my message"
End Sub

Mike
 
Cheers Mike, just what I wanted

Jim
Mike H said:
Right click the worksheet, view code and paste this in

Private Sub Worksheet_Activate()
MsgBox "Please read my message"
End Sub

Mike
Click to expand...
 
You must log in or register to reply here.

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

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
HELP - Retrieving cells from another workbook 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Open an Excel file each time the computer is booted 2
Excel VBA - Problem with Closing Print Preview 0
inconsistent dir() behavior 1
Help to the first sheet 4

Back
Top