| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message when opening a sheet
How do I get excel to produce a message whenever a particular worksheet in a
file is accessed? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message when opening a sheet
Right click the worksheet, view code and paste this in
Private Sub Worksheet_Activate() MsgBox "Please read my message" End Sub Mike "Jim Lavery" wrote: How do I get excel to produce a message whenever a particular worksheet in a file is accessed? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message when opening a sheet
Cheers Mike, just what I wanted
Jim "Mike H" wrote in message ... Right click the worksheet, view code and paste this in Private Sub Worksheet_Activate() MsgBox "Please read my message" End Sub Mike "Jim Lavery" wrote: How do I get excel to produce a message whenever a particular worksheet in a file is accessed? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message when opening a sheet
Your welcome
"Jim Lavery" wrote: Cheers Mike, just what I wanted Jim "Mike H" wrote in message ... Right click the worksheet, view code and paste this in Private Sub Worksheet_Activate() MsgBox "Please read my message" End Sub Mike "Jim Lavery" wrote: How do I get excel to produce a message whenever a particular worksheet in a file is accessed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a pop-up message prior to opening sheet | Excel Discussion (Misc queries) | |||
| Opening Message | Excel Programming | |||
| Message box upon opening file | Excel Discussion (Misc queries) | |||
| Opening an attachment of a message that has a message as attachmen | Excel Programming | |||
| Message "class not registered" opening sheet with macros Excel 97 | Excel Discussion (Misc queries) | |||
Linear Mode
