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

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

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

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

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

Hi, sorry I'm a little late getting to this, I see Mike replied below.
In case you need more help: to record the macro, go to the Tools Menu,
select Macro-Record New Macro, and name it Workbook_Open. Start
recording, and change the zoom to 80%, (in fact, make any other changes
you would like at startup), and then stop recording. Once you have done
this, go to the Visual Basic Editor (Alt + F11), and your macro should
be there in Module 1 in your workbook. Copy the whole thing from Sub to
End Sub, open up the ThisWorkbook object under PERSONAL.XLS in the
Project Window, and paste the code in. Then you should save, close and
start up Excel again - the macro should run and zoom automatically.

I would encourage you to experiment with macros, even if you are not
confident with them - they can make working with Excel particularly much
easier. Have a look also at
http://office.microsoft.com/en-us/ex...346281033.aspx
for a (slightly different) explanation of how to create a startup macro.

Good luck :)

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

Hey Geoff,

Thanks alot mate...


Geoff Ness wrote:
Hi, sorry I'm a little late getting to this, I see Mike replied below.
In case you need more help: to record the macro, go to the Tools Menu,
select Macro-Record New Macro, and name it Workbook_Open. Start
recording, and change the zoom to 80%, (in fact, make any other changes
you would like at startup), and then stop recording. Once you have done
this, go to the Visual Basic Editor (Alt + F11), and your macro should
be there in Module 1 in your workbook. Copy the whole thing from Sub to
End Sub, open up the ThisWorkbook object under PERSONAL.XLS in the
Project Window, and paste the code in. Then you should save, close and
start up Excel again - the macro should run and zoom automatically.

I would encourage you to experiment with macros, even if you are not
confident with them - they can make working with Excel particularly much
easier. Have a look also at
http://office.microsoft.com/en-us/ex...346281033.aspx
for a (slightly different) explanation of how to create a startup macro.

Good luck :)

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