Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show a customised message when a trying to edit a locked cell Emily Ladywell Excel Worksheet Functions 1 May 21st 09 06:03 PM
warning message Mike Excel Discussion (Misc queries) 3 March 10th 06 06:20 PM
How to I get a warning message box shrek Excel Worksheet Functions 3 November 10th 05 12:23 AM
When you click a hyperlink in a cell i get a Warning message David Excel Discussion (Misc queries) 0 October 20th 05 01:46 AM
How do I add a balloon message to a locked cell kden01 Excel Discussion (Misc queries) 2 January 28th 05 06:49 PM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"