Is it possible to set a date, and after that date it's not possible to view a worksheet without entering a password?
Is it possible to set a date, and after that date it's not possible to view a worksheet without entering a password?
You could use the workbook open event and immediately close the workbook if the date has passed and a password in response to an input box request has not been entered.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
To be fair, whilst it is possible, it's not that simple. If a user opens the workbook without enabling macros, your defence is immediately down. Therefore, you would need to hide the worksheet(s )(xlVeryHidden) before you close the workbook. You could then unhide the worksheet(s), with or without a password when you open the workbook with macros enabled.
Be aware that Excel is not a secure environment.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks