View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Norman Jones
 
Posts: n/a
Default 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