ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sheet Protection Properties lost (https://www.excelbanter.com/excel-programming/420190-sheet-protection-properties-lost.html)

Chris

Sheet Protection Properties lost
 
Hi,

I have a worksheet that is protected with user defined properties (eg. allow
to insert row). To run my VBA I need to unprotect the sheet and reprotect it
with the same user defined protection settings. However the api does not
provide the hooks to get at all these settings! Am I missing something?


All times are GMT +1. The time now is 02:44 PM.

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