Hi all,

I hardcode the password to protect the workbook and all its worksheets
within the auto open macro, however, is there a way to auto expire, disable
usaged and prompt to change this password every month say after the 15th with
VBA only?

I know i can insert a date to the spreadsheets or hardcode the dates within
VBA, but i would like to find a more effficient and automated method.

Thanks in advance.

Hi all,

Its ok, i found what i want at the following link.

Thanks again.

http://www.microsoft.com/office/comm...5-ff2638b60ab4

"swiftcode" wrote:

Hi all,

I hardcode the password to protect the workbook and all its worksheets
within the auto open macro, however, is there a way to auto expire, disable
usaged and prompt to change this password every month say after the 15th with
VBA only?

I know i can insert a date to the spreadsheets or hardcode the dates within
VBA, but i would like to find a more effficient and automated method.

Thanks in advance.