What kind of protection is this?
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 ToolsProtection. 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? |
What kind of protection is this?
Unprotect the worksheet
Lock the cell using: Format|Cell|protection tab|check Locked and hidden Protect the worksheet joeu2004 wrote: 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 ToolsProtection. 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? -- Dave Peterson |
What kind of protection is this?
On Jan 3, 11:33*am, Dave Peterson wrote:
Unprotect the worksheet Lock the cell using: Format|Cell|protection tab|check Locked and hidden Protect the worksheet Ding! Got it! Thanks. |
All times are GMT +1. The time now is 10:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com