stop window changes

[fishqqq]

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

 

[Mr B]

Steve,

Try:

Echo off

 

[Mr B]

Be sure that if you use the "Echo off" that you also have an "Echo On" in the
same macro before it completes.

 

[Dale Fye]

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.