ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting a sheet and still allow some features (https://www.excelbanter.com/excel-discussion-misc-queries/96009-protecting-sheet-still-allow-some-features.html)

[email protected]

Protecting a sheet and still allow some features
 
I have a sheet which i can protect, but at the same time I want other
features like formatting of cells, filtering, sorting and such like
features to be allowed. My macro first looks for the formula or
hyperlinks and then lock the sheet and then protect it. I want that to
happen but at the same time I want other features which I mentioned
earlier to be active.
Someone please help,
Nasir.



All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com