Macros crash workbook

[ukphoenix]

I have been testing a workbook for the last few days and have found a problem, im assuming somewhere in the macro below. The issue is when midnight strikes the workbook crashes and wont allow me back in unless i close via task manager and re-open the workbook.

Please Login or Register  to view this content.

P.S. if anyone wants to follow the workbook design then please goto this thread http://www.excelforum.com/showthread.php?t=647029

[ukphoenix]

Bump!!!

[broro183]

hi,

I'm only guessing here...

The Helpfiles show that the Closedowntime needs to be a variant but I wonder if the use of Now causes the following to come into play?
The 2003 Excel Helpfiles state:

Date Data Type:
...
Midnight is 0 and midday is 0.5. Negative whole numbers represent dates before 30 December 1899.

Possibly the principle suggested in the below post will help you:
http://excelforum.com/showthread.php?t=647476
ie test if Now is >11pm & if so change CloseDownTime to be a specific time with tomorrow's date.

Sorry, I haven't coded this but hopefully it will give you something to mull over & develop/test.


Also, there is no line of code to reset the On Error statement, I think you should add the below line of code in somewhere (?):

Please Login or Register  to view this content.

hth
Rob