protect formulae
- Thread starter ahhhmed
- Start date
SirJB7
Excel Rōnin
Hi, ahhhmed!
Protecting cells (containing either formulaes or values) is simple: select a range, Ctrl-1, Protect, Blocked.
Hiding may be accomplished by hiding rows or columns (select them, right button, Hide), and then protecting the worksheet (Review, Protect). Guess my translation succeeds!
But you can't easily avoid copying data from that sheet to another, and obtaining formulae's expression in several ways.
I don't know the full scope of your question, but I hope this will help.
Regards!
Protecting cells (containing either formulaes or values) is simple: select a range, Ctrl-1, Protect, Blocked.
Hiding may be accomplished by hiding rows or columns (select them, right button, Hide), and then protecting the worksheet (Review, Protect). Guess my translation succeeds!
But you can't easily avoid copying data from that sheet to another, and obtaining formulae's expression in several ways.
I don't know the full scope of your question, but I hope this will help.
Regards!
