stop flickering effect on macro ("Application.ScreenUpdating=false" does not work)

hey guys bit of a weired one here

I have this

Please Login or Register  to view this content.

to unhide certain sheets after somthing that hides all but 1 sheets

cSheets is a collection of all sheet names
cHStatus is a collection of sheets that where origanly visible
populated by

Please Login or Register  to view this content.

sActive is the name of the sheet that was originaly active

on running this code i get alot of flashing
i have tryed:
Application.ScreenUpdating = False
but no joy
on every sheet that shows it blinks up and then goes back to the original sheet (sSheet)


i want the sheet to look good and this is the only thing that is bugging me
any ideas??

Do you have any code behind these sheets?

alot of code but just in modules.
the sheet is like 6mb

i only have 2 events though (open and save)

ps: sorry for the delay

Do you have any charts/controls embedded in the sheets?

no charts
sorry not too good on my terminology
is controlls just buttons that activate macros?

if so then yes

Are the buttons from the Forms toolbar or the Control Toolbox?

forms

i didnt know there was a difference

There are lots of differences between the two - the Forms versions are usually more stable when embedded in worksheets. For the purposes of this discussion, I suspect there wouldn't be any benefit in using one over the other though as I think it's the drawing objects layer that is being refreshed and causing the flickering.
Are the controls on the sheets that you are hiding/unhiding or on the sheet that is currently active? (or both?)

both
but its not that its refreshing ( i think)
its more every time a sheet is unhidden it shows for a split second and then reverts back to the sheet that was first shown

Any chance you can post the workbook, removing any confidential information?
Also, has it always done this, or is this new code? There is an update for Excel 2003 (and another for 2007) that seems to cause issues with sheets showing through other sheets, but from the posts I've seen, I would expect the problem to remain at the end of the code if that were the culprit.

ok i can srtip out all the cells and just give blank sheets
i think u will only need the save and accsess macros
give me a min

ok here we go

to open this

make a new workbook with
3 sheets the third sheet need to be called Verification and in cell a1 type 321

i cant upload her for some reason

so i have uploaded here

also just a side note
if you happen to notice anything in the save event that would speed things up a bit it would be worth a mention.

Friel, is the file too big? try zipping it first

I'm not seeing the flickering.
Do you have update KB 973475 applied to your machine? (you can view it in control panel under add/remove programs, with the 'Show updates' option checked).

no not that i can see. what does that do?
running 2003 btw
flicker alsso appers on 2007 though
u not being able to see the flicker is goin to make it hard for you to help lol

teylyn file is just over 900kb
but this may be some kind of security from my workplace system

Tested in 2007 too - still no flicker.
That update is the buggy one I mentioned earlier. The equivalent one for 2007 is KB973593 which has a similar issue with bleed-through from other sheets.