Vba screen updating code dating kp
I have changed it slightly so it loops 10,000 times and I execute it 10 times for sample size.
Screen Updating=False This will stop Excel having to repaint the screen each time the macro does something.
I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.
Is there a way to automatically minimize/hide query windows or disable screen update?
A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.
For example, this code will resize a sub-form within a resized form: [font=Verdana][size=2]You should not have to do all that.