Timer to lock spreadsheet?

[Guest]

Afternoon,

I have a spreadsheet that is accessed by many and needs to be locked at
12noon every Thursday, is their a code/macro that can be put in place to do
this?
I am a novice at vba any help would be greatly appreciated.

Thanks

 

[Chip Pearson]

There is the problem of ambiguity of the date. Today is Tuesday,19-June. Is
this before or after the cut-off date? It is both before the cut-off date of
Thursday, 21-June and after the cut-off date of Thursday , 21-June. Which
date applies today?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

Morning Chip,

This would apply to after the cut of date of every Thursday. So, being that
this Thursday would be the 21-June after 12 noon they would not be able to
input any information in the spreadsheet after that given time.

Thanks

 

[NickHK]

Is this a shared WB, open by many at a time, potenially at the time required
to cease ?

NickHK

 

[Guest]

Hey Nick,

Yes it is a shared WB, but they are aware that they can't all be in at the
same time, some of them go in prior to Thursday, be it the weekend or Monday
to update and modify for the week.

 

[NickHK]

I mean "Shared" in the Excel workbook sense that more than one user can have
the file open for editting at the same time.

NickHK

 

[Guest]

Nick,

I'm sorry, yes they can have it opened for editing at the same time, because
within the WB you have 5 tabs total including the master, the following 4
tabs represents a manager whom updates their data that is linked to the
master.