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.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 |
#4
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Error Message When Opening Excel | Excel Discussion (Misc queries) | |||
Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
Excel Error Message | Excel Worksheet Functions | |||
Excel error message | Excel Discussion (Misc queries) |