| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
A Pop up message in Excel...
Just curious if this can be done... does anyone know a way to make a pop up
message appear in Excel 2003 when an a file opens? Example, I have a particular file that is shared for others to update. When whoever opens the file I would like a little text box to say a few chosen words from me like "THIS FILE IS NOT TO BE MOVE OR RENAMED" or anything else I choose. Thanks in advance, Ian |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
A Pop up message in Excel...
Hi Ian,
In a standard module paste: '============= Public Sub Auto_Open() MsgBox "THIS FILE IS NOT TO BE MOVE OR RENAMED" End Sub '<<============= --- Regards, Norman "Web master" wrote in message ... Just curious if this can be done... does anyone know a way to make a pop up message appear in Excel 2003 when an a file opens? Example, I have a particular file that is shared for others to update. When whoever opens the file I would like a little text box to say a few chosen words from me like "THIS FILE IS NOT TO BE MOVE OR RENAMED" or anything else I choose. Thanks in advance, Ian |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
A Pop up message in Excel...
Perfect. Thanks!!!
"Norman Jones" wrote in message ... Hi Ian, In a standard module paste: '============= Public Sub Auto_Open() MsgBox "THIS FILE IS NOT TO BE MOVE OR RENAMED" End Sub '<<============= --- Regards, Norman "Web master" wrote in message ... Just curious if this can be done... does anyone know a way to make a pop up message appear in Excel 2003 when an a file opens? Example, I have a particular file that is shared for others to update. When whoever opens the file I would like a little text box to say a few chosen words from me like "THIS FILE IS NOT TO BE MOVE OR RENAMED" or anything else I choose. Thanks in advance, Ian |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
A Pop up message in Excel...
In the thisworkbook module in the VB Editor add this code(Right click the
Excel icon in the top right hand corner of Excel and choose view code) Private Sub Workbook_Open() MsgBox "THIS FILE IS NOT TO BE MOVE OR RENAMED", _ vbInformation, "Warning" End Sub -- HTH... Jim Thomlinson "Web master" wrote: Just curious if this can be done... does anyone know a way to make a pop up message appear in Excel 2003 when an a file opens? Example, I have a particular file that is shared for others to update. When whoever opens the file I would like a little text box to say a few chosen words from me like "THIS FILE IS NOT TO BE MOVE OR RENAMED" or anything else I choose. Thanks in advance, Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Excel Program Error - Excel.exe Generated Errors Message | Setting up and Configuration of Excel | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming | |||
| Automating Excel WorkBook With C# Suppress Excel Message Boxes Possible? | Excel Programming | |||
Hybrid Mode
