2 routines. the workbook open one resets the worksheets to 75% other sheets
are set by the second routine whenever a sheet is activated

Private Sub Workbook_Open()
ActiveWindow.Zoom = 75
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveWindow.Zoom = 75
End Sub

"Gor_yee" wrote:

Hi Geoff,

Thanks for the reply, I am not good at macros...would you be able to
assist me further?
Geoff Ness wrote:
The easiest way I know of is to record a macro where you set up the
zoom, toolbars etc the way you want it, then save this under Sub
Workbook_Open in the Personal.xls Workbook. This macro will then run
every time you open Excel.

Hope this is helpful.

Gor_yee wrote:
Hi all, just got a question, you know when you start up excel, it
defaults the zoom to 100%. Is there a way to default it to 80%?Thanks