View original (French)

Block file usage on a specific date

Solved
JESSE76 Posted messages 98 Status Member -  
via55 Posted messages 14391 Registration date   Status Member Last intervention   -
Hello everyone,

Is there a way to block an Excel file (besides the protect function in the review tab) that we can program? Let me explain, I want to sell a file that took me a lot of hours of work, this file is to be updated every month with new dates, and for this reason, I want to ensure that after the 15th of the following month, the file is no longer editable...

Is this possible?
Thank you for your help.

Have a good week everyone.

Configuration: Windows / Firefox 77.0

--
I'm quite resourceful with Excel, but I still consider myself a novice.

3 answers

  1.
    via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    Hello

    One possibility:
    - plan in a very hidden sheet via macro (Sheets("Sheet1").Visible = xlVeryHidden) in which you list the renewal periods with a code next to each of them
    - hide all the sheets in the workbook except for a Welcome sheet and protect the workbook
    - a macro on opening the workbook that asks for a code to unlock the sheets and verifies if the code corresponds to the period before making the working sheets visible

    All while knowing that all these protections can be relatively bypassed or cracked, there are procedures on the Internet to crack passwords and that there isn’t any that is 100% secure

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
  2. via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    In this case, at the base, by macro upon opening the workbook, you lock all the cells of the sheets that you protect with a password.
    The macro on entering the correct monthly password unlocks the editable cells.

    --
    "Imagination is more important than knowledge." A. Einstein
    1
  3. JESSE76 Posted messages 98 Status Member
     
    Thank you for your help,
    I do not want the pages to be hidden but rather that the cells are no longer editable... the user must still have access to the document to view the data.

    0