Screen Updating

[Richard]

Hi,
I'm using ExcelV7.0 for Win95 and have many macros running
in a spreadsheet. I have screen updating turned off in all
of the macro's. But when I run them, some of the macros
still flash the formulas, text etc to the screen but
others run perfectly just showing the hourglass until the
macro completes. I've checked the updating syntax in each
macro and they are identical.

Any clues as to why some work and some don't.

Regards,
Richard

 

[Nutan]

Hi,

If you are using the vb userform then make sure to add the
modal status to the form's show method as follows:

UserForm1.show vbModal

This will stop all screen updates.