Passwords in macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julian Glass - 24 Oct 2006 13:43 GMT

I have recorded which protects worksheets and the workbook with passwords.
The macro is stored in the Personal workbook. When I run the macro against
another workbook it runs ok but the passwords aren't embedded.

What have or done wrong or is this not possible. Looking at the the VB there
is no ref to password or encrypted data there.

Thanks

Reply to this Message

Paul B - 24 Oct 2006 15:28 GMT

Julian, use something like this,

ActiveSheet.Protect Password:="123", DrawingObjects:=True,
Contents:=True, Scenarios:=True
ActiveWorkbook.Protect Password:="123", Structure:=True, Windows:=False

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I have recorded which protects worksheets and the workbook with passwords.
> The macro is stored in the Personal workbook. When I run the macro against
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message