I have created an Excel file that I want to protect the average user
The Excel file has multiple worksheets and some are hiden
Sheet 1 is always visible and it contains the operating instructions
Sheet2, Sheet3 and other worksheets are hidden.
Hidden worksheets are revealed only after all conditions are met and the user accesses the workbook
To open the workbook I set several conditions
I want the following:
- When user try open a workbook, Excel asks for password entry
- The first level of protection is to force the user file to include the option of execution macro in Excel
- The second level of protection is that I wont forbid the user using the SHIFT key on keyboard
- The third level of protection is if the user enters the wrong password files or clicks the Cancel button to the message "Wrong password, please close workbook and try open file again" or something like that
- The fourth level of protection is that after entering the correct password macro in the Workbook_Open event check the limit date, if the date expired to the message "limit date is expired, please contact author of file" and close the Workbook
But if the date is OK to reveal all the sheets in the workbook
Can a VBA expert help?
Bookmarks