RE: 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
.

Relevant Pages

  • RE: hide macro calculations
    ... you can use the status bar to display messages. ... as to switching ... tabs, this may not be necessary if coded right. ... while the calculations took place in the ...
    (microsoft.public.excel.misc)
  • Re: Master Documents - like Excel sheets
    ... >I would like the master document FILE to contain the ... switching using the taskbar is ... >> Why would tabs make a Master Document easier to use? ...
    (microsoft.public.word.docmanagement)
  • Re: Master Documents - like Excel sheets
    ... >I would like the master document FILE to contain the ... switching using the taskbar is ... >> Why would tabs make a Master Document easier to use? ...
    (microsoft.public.word.docmanagement)
  • Re: I love Borland Developer Studio 2006 / Delphi 2006!
    ... > I know Mark Edington has commented that he knows about this and is looking ... delay in switching tabs, and most times tab switching is very fast. ... shows the designer surface, then 3-4 seconds pass, then it switches to ...
    (borland.public.delphi.non-technical)