Need help with code adding password on every sheet in workbook

[g1terra]

i have created a code that's makes many loop throughs to different worksheets. The it currently locks and unlocks before it makes any modifications before macros (unlocking), then after macro (locking).. The issue is now I need to make it lock with a password. I have spent hrs on this.

Any help is greatly appreciated!!

Please Login or Register  to view this content.

[BadlySpelledBuoy]

It would be easier to loop through the sheets in a workbook open event and protect each with a password and the UserInterfaceOnly option set to true.

That way the VBA can still make changes to the worksheets without the need to unprotect / protect, but users will still be blocked from making their changes.

Would that work for you?

BSB

[BadlySpelledBuoy]

Put this in the ThisWorkbook module:

Please Login or Register  to view this content.

BSB

[xlnitwit]

Hi,

Assuming you want the same password for all sheets, perhaps this

Please Login or Register  to view this content.

[xlnitwit]

Just to add, BadlySpelledBuoy's solution is better if it works for what you're doing (userinterfaceonly does not work for everything), especially in newer versions of Excel where protecting and unprotecting is much slower. If it does work, you can remove the Unprotect and Protect lines from your existing code.

[g1terra]

Ok this seemed to work. But i have another macro i need to do the same thing for and when i place that at the beginning it doesnt seem to work, here it is

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Which suggested approach are you using?

BSB

[g1terra]

Actually this one worked best thx!!!