expiry date for passwords

[swiftcode]

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.

 

[swiftcode]

Hi all,

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

Thanks again.

http://www.microsoft.com/office/com...&p=1&tid=db49ca53-e4ee-4361-8b15-ff2638b60ab4