Digital clock on excel

**shilpz** · 02-28-2008, 06:37 AM

where do i copy the code to i dont understand it i formated the cell A! to time
ad pasted the forumula on a button but when i click the button

can you plz send it to me in a xls file plz

thanks in advance

**dominicb** · 02-28-2008, 07:01 AM

Hi shilpz

Find zipped file, time.zip attached.

HTH

DominicB

**royUK** · 02-28-2008, 07:02 AM

I've put Domenic's code in this workbook, it's triggered when the workbook opens

**royUK** · 02-28-2008, 07:03 AM

You weren't there a minute ago Domenic!

**dominicb** · 02-28-2008, 07:24 AM

Hi royUK

Originally Posted by royUK

I've put Dominic's code in this workbook, it's triggered when the workbook opens

Great minds ... and all that kind of thing

I actually called the module from the Workbook_Open event, and also added something into the Workbook_BeforeClose event cancelling the OnTime macro which can cause an error when the file is closed.

DominicB

**Maltese Falcon** · 01-02-2012, 02:08 AM

Originally Posted by royUK

I've put Domenic's code in this workbook, it's triggered when the workbook opens

Hello Roy,
I tried your code and the clock works fine. It is exactly what I want as I require the clock to run automatically when I open the workbook. The only problem is that when I save and close the workbook it re-opens again automatically. If I shut down Excel completely (i.e. "EXIT") this does not happen. I do not always want to shut down Excel as I have other workbooks open. Is there a fix for this problem?
I am using Excel 2003 with Windows XP
Thank You
Maltese Falcon