Control user access

you will get into a mess using that approach

In order to update the password you would need code in the Save event. There you could set the password to the next day. The problem comes when the file does not get opened every day or you have weekends and holidays. You can easily lose track of what password date has been applied.

Also a password that is know, simply because it is the date, defeats the object of protection, no?

try recording the application of password to a file in order to get starting syntax/code

you can use something like this to get password from user

Please Login or Register  to view this content.