Calculation Flicker 
Author Message
 Calculation Flicker

Hello,

I have this spreadsheet that has quite a bit of code behind it and when
there is a calculation, the screen flickers as it goes back and forth to the
12 different sheets that make up this spreadsheet.  Is there any way to
somehow get rid of this effect?  Thanks for any help!

--
Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 01:45:26 GMT  
 Calculation Flicker
You could give Application.ScreenUpdating = False a shot.  If this doesn't
work, then maybe create a form and then have the form showing just before
the you start the calculation process, and then hide the form once the
calculation is done.

Ronald Dodge
Production Statistician
Master MOUS 2000


Quote:
> Hello,

> I have this spreadsheet that has quite a bit of code behind it and when
> there is a calculation, the screen flickers as it goes back and forth to
the
> 12 different sheets that make up this spreadsheet.  Is there any way to
> somehow get rid of this effect?  Thanks for any help!

> --
> Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 01:50:00 GMT  
 Calculation Flicker
Use Application.ScreenUpdating = False before your code.  Set it true when
finished.

Regards

Trevor


Quote:
> Hello,

> I have this spreadsheet that has quite a bit of code behind it and when
> there is a calculation, the screen flickers as it goes back and forth to
the
> 12 different sheets that make up this spreadsheet.  Is there any way to
> somehow get rid of this effect?  Thanks for any help!

> --
> Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 01:56:00 GMT  
 Calculation Flicker
I tried the ScreenUpdating = False method but when I use that, I lose the
functionality of my code that I have.  I also notice at the bottom of Excel,
it says "Calculate" by the word "Ready".  When exactly does it calculate if
I have SreenUpdating switched to false?

What I'm doing is dynamically hiding rows on sheets 2-13 depending on
whether or not a CELL on sheet1 has a name in it or not.  So when the user
is entering and deleting names on sheet1, all the other sheets are
hiding/unhiding those corresponding rows.  I still need this functionality,
I just don't need the flickering.  Any other suggestions?  Thanks again.


Quote:
> Use Application.ScreenUpdating = False before your code.  Set it true when
> finished.

> Regards

> Trevor



> > Hello,

> > I have this spreadsheet that has quite a bit of code behind it and when
> > there is a calculation, the screen flickers as it goes back and forth to
> the
> > 12 different sheets that make up this spreadsheet.  Is there any way to
> > somehow get rid of this effect?  Thanks for any help!

> > --
> > Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 03:38:00 GMT  
 Calculation Flicker
To the best of my knowledge, everything works the same ... it just doesn't
update the screen so you don't see the sheet changes, etc.

You perhaps need to bracket just the bits of code that update, hide rows,
etc and show the use the bits you want the user to see.

Regards

Trevor


Quote:
> I tried the ScreenUpdating = False method but when I use that, I lose the
> functionality of my code that I have.  I also notice at the bottom of
Excel,
> it says "Calculate" by the word "Ready".  When exactly does it calculate
if
> I have SreenUpdating switched to false?

> What I'm doing is dynamically hiding rows on sheets 2-13 depending on
> whether or not a CELL on sheet1 has a name in it or not.  So when the user
> is entering and deleting names on sheet1, all the other sheets are
> hiding/unhiding those corresponding rows.  I still need this
functionality,
> I just don't need the flickering.  Any other suggestions?  Thanks again.



> > Use Application.ScreenUpdating = False before your code.  Set it true
when
> > finished.

> > Regards

> > Trevor



> > > Hello,

> > > I have this spreadsheet that has quite a bit of code behind it and
when
> > > there is a calculation, the screen flickers as it goes back and forth
to
> > the
> > > 12 different sheets that make up this spreadsheet.  Is there any way
to
> > > somehow get rid of this effect?  Thanks for any help!

> > > --
> > > Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 05:06:23 GMT  
 Calculation Flicker
I guess I need help with setting when to calculate.  Is it possible to hold
off calculation of the background sheets until the user actually clicks on
that particular sheet's tab?  If I set ScreenUpdating to false then the
background sheets never get the row hiding done.  It says "Calculate" at the
bottom but I don't know exactly when the calculation is performed...


Quote:
> To the best of my knowledge, everything works the same ... it just doesn't
> update the screen so you don't see the sheet changes, etc.

> You perhaps need to bracket just the bits of code that update, hide rows,
> etc and show the use the bits you want the user to see.

> Regards

> Trevor



> > I tried the ScreenUpdating = False method but when I use that, I lose
the
> > functionality of my code that I have.  I also notice at the bottom of
> Excel,
> > it says "Calculate" by the word "Ready".  When exactly does it calculate
> if
> > I have SreenUpdating switched to false?

> > What I'm doing is dynamically hiding rows on sheets 2-13 depending on
> > whether or not a CELL on sheet1 has a name in it or not.  So when the
user
> > is entering and deleting names on sheet1, all the other sheets are
> > hiding/unhiding those corresponding rows.  I still need this
> functionality,
> > I just don't need the flickering.  Any other suggestions?  Thanks again.



> > > Use Application.ScreenUpdating = False before your code.  Set it true
> when
> > > finished.

> > > Regards

> > > Trevor



> > > > Hello,

> > > > I have this spreadsheet that has quite a bit of code behind it and
> when
> > > > there is a calculation, the screen flickers as it goes back and
forth
> to
> > > the
> > > > 12 different sheets that make up this spreadsheet.  Is there any way
> to
> > > > somehow get rid of this effect?  Thanks for any help!

> > > > --
> > > > Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 05:40:58 GMT  
 Calculation Flicker
JL

Screen updating doesn't effect calculation.  Generally, to speed up your
code and have it look nice for the user, you would use this construct:

Sub
Application.Calculation = xlManual
Application.ScreenUpdating = False
'Code to hide and unhide sheets
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
End Sub

Perhaps you weren't setting the screen updating back to true at the end?

--
{*filter*} Kusleika
MVP - Excel

Post all replies to the newsgroup.


Quote:
> I guess I need help with setting when to calculate.  Is it possible to
hold
> off calculation of the background sheets until the user actually clicks on
> that particular sheet's tab?  If I set ScreenUpdating to false then the
> background sheets never get the row hiding done.  It says "Calculate" at
the
> bottom but I don't know exactly when the calculation is performed...



> > To the best of my knowledge, everything works the same ... it just
doesn't
> > update the screen so you don't see the sheet changes, etc.JL

> > You perhaps need to bracket just the bits of code that update, hide
rows,
> > etc and show the use the bits you want the user to see.

> > Regards

> > Trevor



> > > I tried the ScreenUpdating = False method but when I use that, I lose
> the
> > > functionality of my code that I have.  I also notice at the bottom of
> > Excel,
> > > it says "Calculate" by the word "Ready".  When exactly does it
calculate
> > if
> > > I have SreenUpdating switched to false?

> > > What I'm doing is dynamically hiding rows on sheets 2-13 depending on
> > > whether or not a CELL on sheet1 has a name in it or not.  So when the
> user
> > > is entering and deleting names on sheet1, all the other sheets are
> > > hiding/unhiding those corresponding rows.  I still need this
> > functionality,
> > > I just don't need the flickering.  Any other suggestions?  Thanks
again.



> > > > Use Application.ScreenUpdating = False before your code.  Set it
true
> > when
> > > > finished.

> > > > Regards

> > > > Trevor



> > > > > Hello,

> > > > > I have this spreadsheet that has quite a bit of code behind it and
> > when
> > > > > there is a calculation, the screen flickers as it goes back and
> forth
> > to
> > > > the
> > > > > 12 different sheets that make up this spreadsheet.  Is there any
way
> > to
> > > > > somehow get rid of this effect?  Thanks for any help!

> > > > > --
> > > > > Remove "NOSPAM" to personally email me.



Wed, 19 Jan 2005 06:07:27 GMT  
 Calculation Flicker
I've also had some problems with ScreenUpdating, but it involved crossing
over workbooks.  It worked fine within the same workbook and had no problems
it doing everything that I needed to have done within the same workbook, but
whenever I crossed over to another workbook, that's when nothing would be
done within the 2nd workbook, thus I have avoided using ScreenUpdating for
when dealing with multiple workbooks.  This problem has even existed on
XL2000,SP-2

Ronald Dodge
Production Statistician
Master MOUS 2000


Quote:
> JL

> Screen updating doesn't effect calculation.  Generally, to speed up your
> code and have it look nice for the user, you would use this construct:

> Sub
> Application.Calculation = xlManual
> Application.ScreenUpdating = False
> 'Code to hide and unhide sheets
> Application.ScreenUpdating = True
> Application.Calculation = xlAutomatic
> End Sub

> Perhaps you weren't setting the screen updating back to true at the end?

> --
>{*filter*} Kusleika
> MVP - Excel

> Post all replies to the newsgroup.



> > I guess I need help with setting when to calculate.  Is it possible to
> hold
> > off calculation of the background sheets until the user actually clicks
on
> > that particular sheet's tab?  If I set ScreenUpdating to false then the
> > background sheets never get the row hiding done.  It says "Calculate" at
> the
> > bottom but I don't know exactly when the calculation is performed...



> > > To the best of my knowledge, everything works the same ... it just
> doesn't
> > > update the screen so you don't see the sheet changes, etc.JL

> > > You perhaps need to bracket just the bits of code that update, hide
> rows,
> > > etc and show the use the bits you want the user to see.

> > > Regards

> > > Trevor



> > > > I tried the ScreenUpdating = False method but when I use that, I
lose
> > the
> > > > functionality of my code that I have.  I also notice at the bottom
of
> > > Excel,
> > > > it says "Calculate" by the word "Ready".  When exactly does it
> calculate
> > > if
> > > > I have SreenUpdating switched to false?

> > > > What I'm doing is dynamically hiding rows on sheets 2-13 depending
on
> > > > whether or not a CELL on sheet1 has a name in it or not.  So when
the
> > user
> > > > is entering and deleting names on sheet1, all the other sheets are
> > > > hiding/unhiding those corresponding rows.  I still need this
> > > functionality,
> > > > I just don't need the flickering.  Any other suggestions?  Thanks
> again.



> > > > > Use Application.ScreenUpdating = False before your code.  Set it
> true
> > > when
> > > > > finished.

> > > > > Regards

> > > > > Trevor



> > > > > > Hello,

> > > > > > I have this spreadsheet that has quite a bit of code behind it
and
> > > when
> > > > > > there is a calculation, the screen flickers as it goes back and
> > forth
> > > to
> > > > > the
> > > > > > 12 different sheets that make up this spreadsheet.  Is there any
> way
> > > to
> > > > > > somehow get rid of this effect?  Thanks for any help!

> > > > > > --
> > > > > > Remove "NOSPAM" to personally email me.



Fri, 21 Jan 2005 19:23:59 GMT  
 
 [ 8 post ] 

 Relevant Pages 

1. Flickering during calculation

2. tracking changes to calculations manually(Overriding calculations)

3. Bulk Calculation OR Batch Calculation

4. calculations based on calculations

5. calculations based on calculations

6. calculations based on calculations

7. calculations based on calculations

8. Calculations based on calculations

9. Bulk Calculation OR Batch Calculation

10. Excel spreadsheet calculation defaults to manual calculation.


 
Powered by phpBB® Forum Software © phpBB Group