hide macro calculations
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
|