Display specific Text during set time of day?

[ZEROCOOL UK]

Hi

We use Excel Online to share a spreadsheet between various offices, all within the same country and time zone.

However once per day we need exclusive access to the spreadsheet for various reasons. Naturally no one pays any attention and remain in the spreadsheet preventing us from opening it in full Excel mode.

I was hope to add a formula to on of the cells that states something like the following

=if Time is between 10am and 10.30 am display "Down for maintaince" else "OK to Edit.

Is this possible?

If not a formula may VBA?

[Special-K]

in A1
=IF(AND(TEXT(NOW(),"hh:mm")>"10:00",TEXT(NOW(),"hh:mm")<="10:30:00"),"Down for maintenance","OK")

Of course this still won't stop anyone from editing the file, it's just a message.
Maybe VBA can prevent editing though that side of VBA is beyond me.

[Richard Buttrey]

Hi,

One way. Create a cell with the following formula ad name it say 'StopTest'

Please Login or Register  to view this content.

This returns the current time

Then in another cell somewhere

Please Login or Register  to view this content.

If the intention is to prevent access to any cells in the workbook then I'd use a Workbook Open event macro which pops up a Userform with a label that contains the message and then closes the file down.

See attached example which uses this workbook open event with a UserForm1
To test change the TimeNow > 10 / 24 And TimeNow <= 10.5 / 24 to reflect a current time range.

Please Login or Register  to view this content.

[ZEROCOOL UK]

Hi

Thank you to both people that replied.

All I needed was the first response, I simply need a reminder message, however the second response does give me more options going forward if need be.

Rep added to both replies.

Thanks