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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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

M
  • Solved
Locking cells / rows after a specific date. VBA?
Replies
7
Views
148
myall_blues
myall_blues
KlausW
  • Question
Change Button colour, when VBA lock sheets
Replies
7
Views
324
Micron
M
R
  • Question
Data Entry into Cell Range between 2 specific date periods and to lock after a specific date
Replies
1
Views
214
kevin9999
K
N
  • Question
Locking a row once a value is entered into a cell
Replies
9
Views
798
arturojab
A
A
  • Question
Insert new column(DATE) up to finish month and move to next sheet
Replies
0
Views
154
Amer Omar
A

Forum statistics

Threads
1,216,076
Messages
6,128,669
Members
449,463
Latest member
Jojomen56

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