Hi Guys, lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has macro which runs automatically and sometimes it throws OLE error for which we need to MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and whenever that OLE error occurs it should click OK automatically. i know there is some API to click OK button but i dont know anything about it.
is it possible to create such a macro to monitor another macro. there are N numbers of Macros like wkbk_run so i cannot keep that code in all the workbook. so i want another macro to monitor all the macro which runs automatically. so it will be like monitor macro will run when 1st macro starts running and that will stop running when last macro gets over. thanks guys. please let me know if is it possible? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
