MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER

[WhytheQ]

Is the following code exposing a bug in Excel?

Sub Auto_Open()

Application.Screenupdating = False

Sheets(1).Select
ActiveWindow.SmallScroll ToRight:=-100
ActiveWindow.SmallScroll Down:=-100

Range("A1:N46").Select
ActiveWindow.Zoom = True

Application.Screenupdating = True

End sub

Range("A1:N46") is the range that I want to fill the screen, whoever
opens the workbook(with whatever configuration of toolbars they have on
their screen).
On openeing this workbook there is a horrible flicker - any way to get
rid of it, or workaround it?!!

Any help greatly appreciated

Jason Quirk

 

[Tom Ogilvy]

I can't reproduce anything I would describe as a horrible flicker. If you
mean the appearance of the screen changes, then I would expect that.

 

[WhytheQ]

......any way round it Tom?: I know it's only cosmetic Tom, but I'd
rather not see the screen changes
(that's why I've included the Application.Screenupdating method - but
this method doesn't seem to have much affect in the auto_open routine).


Any sort of workaround would be appreciated.

Regards
Jason Q