software

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
quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot; or anything else I choose.

Thanks in advance,

Ian
Hi Ian,

In a standard module paste:

'=============gt;gt;
Public Sub Auto_Open()
MsgBox quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot;
End Sub
'lt;lt;=============---
Regards,
Normanquot;Web masterquot; gt; wrote in message
...
gt; Just curious if this can be done... does anyone know a way to make a pop
gt; up message appear in Excel 2003 when an a file opens? Example, I have a
gt; particular file that is shared for others to update. When whoever opens
gt; the file I would like a little text box to say a few chosen words from me
gt; like quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot; or anything else I choose.
gt;
gt; Thanks in advance,
gt;
gt; Ian
gt;
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 quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot;, _ vbInformation,
quot;Warningquot;
End Sub
--
HTH...

Jim Thomlinsonquot;Web masterquot; wrote:

gt; Just curious if this can be done... does anyone know a way to make a pop up
gt; message appear in Excel 2003 when an a file opens? Example, I have a
gt; particular file that is shared for others to update. When whoever opens the
gt; file I would like a little text box to say a few chosen words from me like
gt; quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot; or anything else I choose.
gt;
gt; Thanks in advance,
gt;
gt; Ian
gt;
gt;
gt;

Perfect. Thanks!!!

quot;Norman Jonesquot; gt; wrote in message
...
gt; Hi Ian,
gt;
gt; In a standard module paste:
gt;
gt; '=============gt;gt;
gt; Public Sub Auto_Open()
gt; MsgBox quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot;
gt; End Sub
gt; 'lt;lt;=============
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;Web masterquot; gt; wrote in message
gt; ...
gt;gt; Just curious if this can be done... does anyone know a way to make a pop
gt;gt; up message appear in Excel 2003 when an a file opens? Example, I have a
gt;gt; particular file that is shared for others to update. When whoever opens
gt;gt; the file I would like a little text box to say a few chosen words from me
gt;gt; like quot;THIS FILE IS NOT TO BE MOVE OR RENAMEDquot; or anything else I choose.
gt;gt;
gt;gt; Thanks in advance,
gt;gt;
gt;gt; Ian
gt;gt;
gt;
gt;