stop window changes "fishqqq[ at ]hotmail.com" <fishqqq[ at ]hotmail.com> 12/21/2008 9:06:22 PM I have a macro that open and closes multiple forms etc while it is running. Is there a way to block all the screens from 'flashing' on / off without preventing the macro from doing it's job? this flashing on/off causes the users concern and would be best if blocked somehow. any suggestions are greatly appreciated. Tks Steve

RE: stop window changes Mr B 12/22/2008 3:30:03 AM Steve, Try: Echo off -- HTH Mr B askdoctoraccess dot com "fishqqq[ at ]hotmail.com" wrote: [Quoted Text] > I have a macro that open and closes multiple forms etc while it is > running. > Is there a way to block all the screens from 'flashing' on / off > without preventing the macro from doing it's job? this flashing on/off > causes the users concern and would be best if blocked somehow. > > any suggestions are greatly appreciated. > Tks > Steve >

RE: stop window changes Mr B 12/22/2008 3:31:00 AM Be sure that if you use the "Echo off" that you also have an "Echo On" in the same macro before it completes. -- HTH Mr B askdoctoraccess dot com "fishqqq[ at ]hotmail.com" wrote: [Quoted Text] > I have a macro that open and closes multiple forms etc while it is > running. > Is there a way to block all the screens from 'flashing' on / off > without preventing the macro from doing it's job? this flashing on/off > causes the users concern and would be best if blocked somehow. > > any suggestions are greatly appreciated. > Tks > Steve >

RE: stop window changes Dale Fye 12/22/2008 3:39:01 PM Basically, Echo Off/On inhibits screen updates, so you need to make sure you have a good error handler, in case something goes wrong within your macro. Otherwise, if you encounter an unhandled error, you will never get your screen updated. I so rarely use macros, that I'm not sure how to implement error checking within one. -- HTH Dale email address is invalid Please reply to newsgroup only. "fishqqq[ at ]hotmail.com" wrote: [Quoted Text] > I have a macro that open and closes multiple forms etc while it is > running. > Is there a way to block all the screens from 'flashing' on / off > without preventing the macro from doing it's job? this flashing on/off > causes the users concern and would be best if blocked somehow. > > any suggestions are greatly appreciated. > Tks > Steve >