hide macro calculations

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi,

I have a complicated macro that runs for about 30 seconds and switches
between tabs frequently. This process produces a 'flashing' effect. I'd
prefer if the end user would not have to see this and would instead get a
message that said 'working..." while the calculations took place in the
background. At the very least I would like the calculations to take place in
the background without having to see the tabs switch back and forth for 30
seconds. Is this possible?

Thanks!

Adam
 
Maybe

Range("A1").Value = "Working"
Application.ScreenUpdating = False
'Your code
Application.ScreenUpdating = True

Mike
 
You can stop the screen flashing by turn off ScreenUpdating:

'Turn off screen updating.
Application.ScreenUpdating = False

This can also make your macro run faster (because it 's not spending time
repainting the screen). Be sure to set ScreenUpdating back to True at the end
of your macro (if control jumps to an error handling routine, that should
have the following code too):

'Turn on screen updating.
Application.ScreenUpdating = True

Hope this helps,

Hutch
 
hi
probably. you can use the status bar to display messages. as to switching
tabs, this may not be necessary if coded right. and there is a command...
application.screenupdateing = false....which should cut down the flicker.
post your code. i've got some things to do but i'll look at it later.

Regards
FSt1
 
Thanks everyone! This works great.

FSt1 said:
hi
probably. you can use the status bar to display messages. as to switching
tabs, this may not be necessary if coded right. and there is a command...
application.screenupdateing = false....which should cut down the flicker.
post your code. i've got some things to do but i'll look at it later.

Regards
FSt1
Click to expand...
 
Back
Top