Hi Jason,

My second time posting this question:

On opening this workbook you can see the screenupdating - any way to
hide this, or a possible workaround ?!!


Run all of the following:

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

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

before closing/saving the workbook.

---
Regards,
Norman



"WhytheQ" wrote in message
oups.com...
My second time posting this question:

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 application).
On opening this workbook you can see the screenupdating - any way to
hide this, or a possible workaround ?!!

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


Any help greatly appreciated
Jason Quirk