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.