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