ExcelBanter - how do i protect all worksheets in a workbook at one time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i protect all worksheets in a workbook at one time (https://www.excelbanter.com/excel-discussion-misc-queries/53329-how-do-i-protect-all-worksheets-workbook-one-time.html)

Dennis

how do i protect all worksheets in a workbook at one time

I have tried to follow directions given earlier and have been unseccessful.
This is my first time to attempt putting in a code so I am must be missing
some action. How do I save the code after entering it or how do I activitate
the code?

All times are GMT +1. The time now is 03:51 PM.