how to turn off the screen while updating using running macro in QV?

[Anonymous]

Hi

I am exporting graphs from multiple sheets and when the macro runs it keeps moving across the sheets while exporting these graphs. Is there a way to turn off screen changes while the macro is executing so that the user need not move across the screen and stays put at the same screen where the button is present.

[swuehl · Accepted solution]

I don't think that's possible.

Maybe it's enough to return to the (i.e. activate the) sheet at the end of the macro where the button was pressed?

[asgardd2]

May be create a big text object (the size of a sheet, with white or custom background color + text "Exporting...") and make this object visible on each sheet,then macro is running.

In this way, user will not see what is happening, (only moving across the sheets)

[Anonymous]

Thanks..I used this solution for the user to get back to the sheet where the button is pressed but the user still sees the pages being traversed while exporting the images.

[Anonymous]

Hi Anton

I didn't understand your solution ..Can you please elaborate a bit?