Disabling Workbook/Sheet Protection Via Code 1

[TheMus]

There is a workbook that has an auto_open macro that updates and calculates. The workbook sheets want to be password protected after the auto_open macro updates and calculates. Is there a VBA statement that will disable password protection at the start of the code and then enable just before completing?

Thanks,

Rus

 

[dsi]

Use the Worksheet.Protect and Worksheet.Unprotect methods to toggle the protection. You can specifiy the password for these methods.

 

[TheMus]

Thanks for sharing your knowledge!