Auto Open
-----Original Message-----
Hi Karen,
Try double quotes:
MsgBox "To update list - Make changes to cell ""B3""
only", _
vbOKOnly, "ATTENTION"
---
Regards,
Norman
"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
Thank you so much for your help.
Karen
|