What kind of protection is this?

  • Thread starter Thread starter joeu2004
  • Start date Start date
J

joeu2004

I am looking at a worksheet that has some kind of protection imposed.
I am curious about what kind of protection has been set.

I can select the cell (dark border around the cell) and see the value
of the formula. But when I select the cell, I cannot see the formula.

I have tried to duplicate the protection security in my own worksheet
by using Tools>Protection. But I have not stumbled onto the right
combination of options that duplicate that behavior exactly -- namely
that allows me to select the cell, but no see the formula.

Any insights?
 
Unprotect the worksheet
Lock the cell using:
Format|Cell|protection tab|check Locked and hidden
Protect the worksheet
 

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

Protect woksheet and keep using outline capabilities 1
Hiding Formulas and Being Able to Make Changes 2
protecting formulas without protecting sheet so grouping still wor 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Sheet Protection 3
How to change format protection default to unlocked? 2
Protected Worksheet Tab Order 1
Protect Only Certain Cells 2

Back
Top