lock only formula cells without protecting sheet - leave open

  • Thread starter BLANK JUNK MAIL RECEIVED - CREATE RULE
  • Start date
B

BLANK JUNK MAIL RECEIVED - CREATE RULE

protected sheet does not allow me to change info on cells that do not have
formula and which should allow me to input info that is used by other formula
cells.
PROTECTING SHEET BLOCKS THE OPEN CELLS AND IT SHOULD NOT. UNPROTECTED
WORKSHEET RISK ERASING FORMULAS WHEN INPUT IS MADE.
I CAN ALSO BLOCK THE NAME TITLES THAT I WANT TO PRESERVE IN CELLS.
FINALLY, THE OPTION FOR THIS SHOULD BE IN THE TOOLS, OPTION AS: PROTECT
LOCKED FORMULAS, ALLOW CHANGE IN UNLOCKED CELLS.
WHEN I WANT TO CHANGE FORMULA, EITHER MAKE IT AN OPTION TO ALLOW FORMULA
CHANGES TO LOCK CELLS OR NOT, OR AT LEAST A WARNING MESSAGE. ANOTHER OPTION
IS TO CHOOSE COLOR SELECTION BACKGROUND TO VIEW ALL LOCKED OR UNLOCKED CELLS
BY COLOR DIFFERENTIAL WHEN DESIRED.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1dc2502&dg=microsoft.public.excel.programming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Override protected sheet message? 4
Alert messages 2
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Paste Value 1
Pivot tables wont work in protected sheet? 3
Password protecting multiple pages, and then some. 7
Lock Cells with Hyperlink 3
Protect Worksheet Macro 2

Top