P
patsy
I need to know how to create a pop-up message when a worksheet is opened. I
need it to say "PUT IN REQ # AND DATE NEEDED NOW". I already have the
following VBA Code to add the current date:
ActiveSheet.Unprotect
Range("T10") = Now()
ActiveSheet.Protect
ActiveSheet.Unprotect Password:="password"
Range("T10") = Now()
ActiveSheet.Protect Password:="password"
What code and where does it go to add the pop-up box?
I would appreciate any help possible.
Thanks.
need it to say "PUT IN REQ # AND DATE NEEDED NOW". I already have the
following VBA Code to add the current date:
ActiveSheet.Unprotect
Range("T10") = Now()
ActiveSheet.Protect
ActiveSheet.Unprotect Password:="password"
Range("T10") = Now()
ActiveSheet.Protect Password:="password"
What code and where does it go to add the pop-up box?
I would appreciate any help possible.
Thanks.