message box?

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

This will be very basic for you guys,
I want to create a message box when somebody tries to change any part of my
workbook, with some kind of "copyright" notice.
I presume I protect the workbook first, then enter some kind of code.
Anybody help with this please?
 
If you protect each of the worksheets, Excel will generate the popup for
you.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bob Phillips said:
If you protect each of the worksheets, Excel will generate the popup for
you.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
Thanks got it, but how do you edit the text in the message box?
 
With this particular function, you can't I am afraid, it is built-in.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Craig
There are a couple of ways you can go about this. If you simply don't
want anyone to make any changes to your file and then save the file (change
your saved file) you can use a macro to prevent anyone from saving the file.
This way, any changes made to your file will be discarded once the file is
closed.
Another way is to place a Worksheet_Change event macro in each sheet
module. This macro will fire when any cell is changed. This macro can be
written to undo any change that has been made and then display a message box
saying anything you want. Post back if either one of the above fits your
needs and you want more help with the details. HTH Otto
 
Back
Top