Daily posts of Excel tips…and other stuff
Archive for the ‘Protection’ Category.
Do you have worksheets in your workbook that contain sensitive data? Do these workbooks contain other data that you need to be available to all? Are you looking for a way to keep your sensitive data under wraps? Well look no further. I have the answer.
You can’t.
If a user knows how, [...]
I’ve never noticed the “Allow Users to Edit Ranges” option under Tools > Protection until Shane pointed it out the other day. This seems like it could be fairly useful if you have decent domain level groups established. One way I can see to use this is in cross-departmental collaboration. What? [...]
We all keep sensitive data in Excel. Whether it’s your secret checking account or the phone numbers of your mistresses, you don’t want your wife opening just an old Excel file she wants. To prevent that, you can keep your sensitive Excel files on a floppy and hide it in the toilet tank, [...]
One aspect of Excel’s protection is the ability to hide the contents of a cell. The cell still displays, but the formula bar remains empty when the cell is selected. This is useful if you don’t want the users to see the formula for the cell.
On the Protection tab of Format>Cells, check the [...]
