Kelvin Stott
Active Member
- Joined
- Oct 26, 2010
- Messages
- 338
Please help:
I need a macro that will automatically protect each sheet in a workbook when the workbook is saved, but only those sheets where the value of a certain cell has a specific value.
For example, when the workbook is saved, all sheets with cell B2 = "YES" should be protected, but not the others.
Any ideas how to do this please?
I need a macro that will automatically protect each sheet in a workbook when the workbook is saved, but only those sheets where the value of a certain cell has a specific value.
For example, when the workbook is saved, all sheets with cell B2 = "YES" should be protected, but not the others.
Any ideas how to do this please?