MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
 

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

MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
 

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.

--
Regards,
Tom Ogilvy


"WhytheQ" wrote in message
oups.com...
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

MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
 

......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