Results 1 to 3 of 3

Protecting Excel Files - Workbook_Open()

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-10-2010
    Location
    europe
    MS-Off Ver
    Excel 2007
    Posts
    149

    Question Protecting Excel Files - Workbook_Open()

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1