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

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)




"Norm" wrote in message
...
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

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

"Chip Pearson" wrote:

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)




"Norm" wrote in message
...
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

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

NickHK

"Norm" ...
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

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" wrote:

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

NickHK

"Norm" ...
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

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

"Norm" ...
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" wrote:

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

NickHK

"Norm" ...

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

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.

"NickHK" wrote:

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

"Norm" ...
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" wrote:

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

NickHK

"Norm" ...

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