Auto change pwrd in macro when user changes pwrd using protect sheet in the toolbar?

[nva2k4]

I'm wondering if this is possible. I would like these specific lines of code to change when the user changes the password from within the workbook. For instance: the user clicks on protect sheet in the review tab and creates a password. After the password is created, the macro code attached to the worksheet will automatically change along with it.

Please Login or Register  to view this content.

Thanks in advance.