Expiry date with password

[cobwebs2222]

hi people,

Ive been trying to do this for ages now, but decided i need further help!
Im fairly new to VB but getting the hang of it, however this one gets passed me.

I have made a spreadsheet that works out figures and conversion rates and stuff, however i would like it to expire with the option of a password lets say for example after 30 days, this will effectivly dissable, or close the spreadsheet down until a password is put in, then it will all come back to life.

ive been trying to think of a way round this now for days, but headache after headache i still cant get it to work. The formula doesnt have to be that secure, as the people using it im certain would never even look for it untill its too late!


I really hope some one out there can help me

and any suggestions would be most welcome.

Cheers x

 

[ExcelChampion]

Be careful about having code delete a workbook where others may enter data. The code and formulas in the workbook may be yours but any data someone enters is THEIR data, and there may be laws in your neck of the woods about purposefully destroying someone's data. Just something to be aware of...