VB ScreenUpdate = False

[HotNumbers2001]

How Can I make the Macro Run without showing all the steps on screen while it is profoerming the Macro.

I used the following code in the begining of the Macro but doesn't seem to work. Does Anyone have any ideas?


Application.ScreenUpdating = False

 

[Juan Pablo González]

It should work... unless all the steps that you're doing are one a Userform. Are they ?

 

[HotNumbers2001]

No. They are in a Module

 

[Juan Pablo González]

Can you post the trouble code ? and what version are you using ?

 

[HotNumbers2001]

Ans = MsgBox("Convert SubLedger?", vbYesNo + vbQuestion, "SAP SubLedger Macro")
If Ans = vbYes Then
Application.ScreenUpdating = False

...more code
...more code
...more code

Beep
Beep
Else
Exit Sub
End If



End Sub

 

[izzy]

WOW what a trip. I logged on to ask a very simular question on how to "visualy" hide the work of my macros. My boss keeps trying to inturupt procedures because he's to impatient to wait 30 seconds and thinks he needs to click everything on the screen. :x

 

[Juan Pablo González]

You *should* always code something like

Application.ScreenUpdating = False

'Your code here

Application.ScreenUpdating = True

you didn't say what version are you using...

 

[Smitty]

For added measure, in case what you're doing can create dialogue boxes (Save, Close, etc.), I also add Application.DisplayAlerts = False/True.

Smitty

 

[Nimrod]

HotNumbers2001 ... Could I see the entire code please

 

[Smitty]

IZZY:

because he's to impatient to wait 30 seconds and thinks he needs to click everything on the screen.

Have you thought of putting in a progress indicator or a "Disable dummies" workaround? You can use some text in a UserForm that's called with the macro that says "Hey Boss, chill out you %^&$*# pinhead...I'll be done in a minute...Mess with this again and I'll melt down your hard drive if you don't give me a raise". It will stay on screen until the macro is done. Or pop up a fake tic-tac-toe game...

I'd be happy to post the code for that for you, but e-mailing it might be easier, so you don't have to build the associated form.

HTH,

Smitty