Assign time-lock to workbook to restrict access after a certain date/time

mmcallister12

New Member
Joined
Apr 1, 2022
Messages
2
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
Hi There! I am trying to design a macro that will not allow the user to open a workbook after a certain date/time. There is an old post that shares the code to do something close to this, but I need to make a few adjustments to the code to fit my needs. I need help figuring out these modifications :0). Here is the old thread: Assign Expiry Date(Time-Lock) to Excel Workbook.

These are the changes I'm trying to make to adapt the code shared in this post to my needs:
1) How would I make the expiration date for a specific date and time? Isdate is used to validate whether a date is entered by the user, is there an alternative function that can handle a time in addition to the date?
2) I don't want the user to be able to view the content of the excel file after the expiration date, not just lock the cell values. Is there a way to do that?

Thanks!
Michelle
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hi there! One other thing I just realized...I need to restrict users' ability to save a copy of the file to get around the restricted access.

Thanks!
Michelle
 
Upvote 0
Could you please send me steps or code need to be done to restrict the access with time and date.
Hope you'll reply as soon as possible.

Thank you.
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top