Workbook Protection

  • Thread starter Thread starter J Lenz
  • Start date Start date
J

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

(e-mail address removed)
 
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.
 
Back
Top