Workbook Protection

[J Lenz]

[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

[email protected]

 

[Jim Rech]

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.