ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet Protection status (https://www.excelbanter.com/excel-worksheet-functions/112101-worksheet-protection-status.html)

JimB

Worksheet Protection status
 
Is there a worksheet function that will return the status of the worksheet as
being "protected" or "unprotected" that I can display?

Thanks for any and all assistance.

JimB

Tieske

Worksheet Protection status
 
Not that I know, but in VBA, the status can be determined (and altered), so
you should be able to create your own function.

Tieske

"JimB" wrote in message
...
Is there a worksheet function that will return the status of the worksheet
as
being "protected" or "unprotected" that I can display?

Thanks for any and all assistance.

JimB





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

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