Workbook Protection
 

[ActiveWorkbook.Protect]

Has anyone noticed that the code above simply toggles
workbook protection on and off? In my application, the
execution of this line of code protects the workbook
every other time.

J Lenz

Workbook Protection
 

I never noticed that but I don't think I ever use it without arguments:

ActiveWorkbook.Protect , True, True

I guess you should too to be guaranteed the result you want.

--
Jim Rech
Excel MVP