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

"Adam" wrote:

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

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

"Adam" wrote:

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

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

"Adam" wrote:

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

Thanks everyone! This works great.

"FSt1" wrote:

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

"Adam" wrote:

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