Lock cells without protecting sheet?
Is there a way to lock (or something like it) cells in a sheet without
protecting the whole sheet? I've got some cells that need to locked from users changing the formulae, but cannot protect the sheet because I'm also using the outlining feature (grouping) to expand and collapse rows. I guess an alternative question would be....is there a way to use the outlining feature in a protected sheet? |
RBee,
You could use the worksheetchange event to try to protect those cells from changes. However, if the workbook is opened with macros disabled, then you are out of luck. HTH, Bernie MS Excel MVP "RBee" wrote in message ... Is there a way to lock (or something like it) cells in a sheet without protecting the whole sheet? I've got some cells that need to locked from users changing the formulae, but cannot protect the sheet because I'm also using the outlining feature (grouping) to expand and collapse rows. I guess an alternative question would be....is there a way to use the outlining feature in a protected sheet? |
You could apply protection the the sheet, after leaving some cells
unprotected, then use buttons to call a macro which unprotects / modifies display / applies protection again. |
All times are GMT +1. The time now is 08:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com