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

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" <webmaster@teamcomtech.com> wrote in message
news:eX8I7lqIGHA.2680@TK2MSFTNGP09.phx.gbl...
> 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
>

Perfect. Thanks!!!

"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:e8ZByrqIGHA.3000@TK2MSFTNGP14.phx.gbl...
> 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" <webmaster@teamcomtech.com> wrote in message
> news:eX8I7lqIGHA.2680@TK2MSFTNGP09.phx.gbl...
>> 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
>>
>
>

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
>
>
>