Replace your OnTime statement in MyMacro

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"buzzharley" wrote
in message ...

Thanks for the help!! Where should I put-

Application.OnTime Date + 1 + TimeValue("21:30:00"), "Button2_click"
Make it a new macro or add it to the macro button? Thanks alot


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile:
http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=558403