Forum Discussion
Losing Protect Sheet Features when saving
I have a number of sheets in a workbook which are protected and the Format cells option is ticked. However when unprotecting and reprotecting through vba and saving the file under a different name the...
The code is simply. Sheet1. Protect
If you include the arguments the Protect method has with the proper values for them it will work as expected.