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
Master MOUS 2000
> 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:
> 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?
> MVP - Excel
> Post all replies to the newsgroup.
> > I guess I need help with setting when to calculate. Is it possible to
> > off calculation of the background sheets until the user actually clicks
> > 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
> > bottom but I don't know exactly when the calculation is performed...
> > > To the best of my knowledge, everything works the same ... it just
> > > 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
> > > 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
> > the
> > > > functionality of my code that I have. I also notice at the bottom
> > > Excel,
> > > > it says "Calculate" by the word "Ready". When exactly does it
> > > if
> > > > I have SreenUpdating switched to false?
> > > > What I'm doing is dynamically hiding rows on sheets 2-13 depending
> > > > whether or not a CELL on sheet1 has a name in it or not. So when
> > 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
> > > > > Use Application.ScreenUpdating = False before your code. Set it
> > > when
> > > > > finished.
> > > > > Regards
> > > > > Trevor
> > > > > > Hello,
> > > > > > I have this spreadsheet that has quite a bit of code behind it
> > > 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
> > > to
> > > > > > somehow get rid of this effect? Thanks for any help!
> > > > > > --
> > > > > > Remove "NOSPAM" to personally email me.