running macros at set times of day ???

[ADE]

Hello

I don't know if this is possible or not,hopefully you can tell me.

I would like to run a series of macros(e.g
cleartable,ranktable,printtable) at a set time on certain days of th
week for example when the time in cell B6 hits 22:30.

I would only want the series of macros to run when todays date is
working day.
I would like the macro to run o
Monday,Tuesday,Wednesday,Thursday,Friday

On Saturdays and Sundays when the time hits 22:30 in cell B6 i don'
want anything to happen.


Can you help

Thanks


Ad

 

[Frank Kabel]

Hi
have a look at bthe OnTime method:
http://www.cpearson.com/excel/ontime.htm

 

[Dave Hawley]

Hi Ade

Try this page
http://www.ozgrid.com/Excel/run-macro-on-time.htm

Post back if you get stuck.


***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****