Locked cells
Is there any simple way of identifying all locked cells on a sheet?
-- Boots |
Locked cells
Are you using Format|Conditional Formatting for anything?
If no, then how about using it to show the locked/unlocked cells? Select your range (ctrl-A for all the cells). Format|Conditional formatting formula is: =CELL("protect",A1) (Use the activecell's address instead of A1.) Boots wrote: Is there any simple way of identifying all locked cells on a sheet? -- Boots -- Dave Peterson |
All times are GMT +1. The time now is 11:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com