ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect all Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/31196-protect-all-sheets.html)

Phil Osman

Protect all Sheets
 
I would like a macro that will protect all sheets in a workbook. However, to
confuse things I would like them all to be protected with the protection
settings that currently apply to each sheet (eg. Allow cell formatting, etc).

Hopefully this is possible......


All times are GMT +1. The time now is 09:57 PM.

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