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...
I'd need to see your current VBA code that does the protecting.
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.