Thread: Auto Open
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Auto Open

Hi Karen

MsgBox "To update list - Make changes to cell ""B3"" only"

Cheers
JulieD

"Karen" wrote in message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub