Forum Discussion

Stoney79's avatar
Stoney79
Copper Contributor
Mar 04, 2020

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 protect sheet option are reverting back to the default setting. Select locked and unlocked cells. How do a retain the format cells option?
excel
Macros and VBA

3 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 05, 2020
    I'd need to see your current VBA code that does the protecting.
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Mar 05, 2020
        If you include the arguments the Protect method has with the proper values for them it will work as expected.

Resources