Customizing the Locked Cell Warning Message Box
Phil,
I don't believe the default cell locked message can be modified.
In Excel 2002, when protecting the sheet, you have the option to not allow selection of locked cells.
That would prevent the default locked cell message from appearing.
You could also insert a comment into the cell.
The comment appears no matter whether cell selection is allowed or not.
You could also lightly shade locked cells (or the unlocked cells) and put a message
on the sheet that entries should be (not) made in the colored cells.
Regards,
Jim Cone
San Francisco, CA
"Phil Hageman" wrote in message ...
Cell D10 in the Customer worksheet has the following formula: =IF(Rationale11!E18<"",Rationale11!E18,""), and is locked with the
sheet protected.
If a user tries to enter data into D10 they get the usual default Read-only warning message and cannot enter data.
Is there a way to have a custom message come up saying, €śThis data is populated from the €śRationale€ť worksheet.€ť €“ rather than the
default message?
Thanks,
Phil
|