I would like to create macro to protect and to unprotect my workbook. User
should enter the password for protecting and later for unprotecting of the
workbook. Alternatively the password string can be specified in the macro
itself as macro will be be protected by itself from viewing.
What is the code I should use for this ?

Thanks for suggestions.

Tony

I have my problem solved using info from other postings.

Tony

"Tony" wrote:

I would like to create macro to protect and to unprotect my workbook. User
should enter the password for protecting and later for unprotecting of the
workbook. Alternatively the password string can be specified in the macro
itself as macro will be be protected by itself from viewing.
What is the code I should use for this ?

Thanks for suggestions.

Tony