RE: hide macro calculations
- From: Adam <Adam@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 11 Apr 2008 10:00:01 -0700
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
- References:
- hide macro calculations
- From: Adam
- RE: hide macro calculations
- From: FSt1
- hide macro calculations
- Prev by Date: Full Screen View
- Next by Date: Re: How can I restore a previous version of an excel document?
- Previous by thread: RE: hide macro calculations
- Next by thread: How can I restore a previous version of an excel document?
- Index(es):
Relevant Pages
|
