View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norm Norm is offline
external usenet poster
 
Posts: 71
Default Timer to lock spreadsheet?

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