Running a macro based on the time
 

I have a spreadsheet that runs throughout the day. There is a time function
built in using =now() and Text(A1,"H:MM"). Is there a way to use the time to
run a macro? I want the macro to run everyday at 16:00.

Thanks.

Running a macro based on the time
 

hi
that would be the on time event.
look up the on time method in vb help.
also see this site.
http://www.cpearson.com/excel/OnTime.aspx

regards
FSt1

"WNYC" wrote:

I have a spreadsheet that runs throughout the day. There is a time function
built in using =now() and Text(A1,"H:MM"). Is there a way to use the time to
run a macro? I want the macro to run everyday at 16:00.

Thanks.