lock cell/sheet after time interval

Status
Not open for further replies.
C

cybrkada

New Member
Joined
Apr 8, 2014
Messages
42
I would like to lock cells or the whole sheet after our working shift ends (end of business day) to prevent users from modifying data on the next working day. My tabs on the sheet includes date in format MMDD. So today (sheet 0724) is a workable sheet and it should be locked tomorrow, subsequently, sheet 0723 which is my previous sheet (the date yesterday) should be locked for now. Is this possible?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
to add to my post above, a new sheet is added everyday (date today). So i want to enforce the rules on every sheet added.
 
Upvote 0
Status
Not open for further replies.

Similar threads

KlausW
  • Question
Change Button colour, when VBA lock sheets
Replies
7
Views
294
Micron
M
R
  • Question
Data Entry into Cell Range between 2 specific date periods and to lock after a specific date
Replies
1
Views
197
kevin9999
K
N
  • Question
Locking a row once a value is entered into a cell
Replies
9
Views
739
arturojab
A
A
  • Question
Insert new column(DATE) up to finish month and move to next sheet
Replies
0
Views
135
Amer Omar
A
X
  • Question
Locking/unlocking a cell with a Combo Box value Mouse click problem
Replies
0
Views
497
XrayLemi
X

Forum statistics

Threads
1,215,390
Messages
6,124,670
Members
449,178
Latest member
Emilou

Share this page

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