Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show a customised message when a trying to edit a locked cell | Excel Worksheet Functions | |||
warning message | Excel Discussion (Misc queries) | |||
How to I get a warning message box | Excel Worksheet Functions | |||
When you click a hyperlink in a cell i get a Warning message | Excel Discussion (Misc queries) | |||
How do I add a balloon message to a locked cell | Excel Discussion (Misc queries) |