Need HELP: Change the Zoom by Default

[JuliaKs]

I need that each Workbook and each Sheet in new Workbook
will open with zoom of 120% automatically.

 

[Debra Dalgleish]

If you want new sheets to be inserted with the same zoom setting, you
can create a sheet template:

Open a new workbook.
Remove all sheets except one
Choose Save As
From the Save As Type dropdown, choose Template (*.xlt)
Name the File -- Sheet.xlt
Save it in the XLStart folder
(usually in Program Files/Microsoft Office/Office)

 

[JuliaKs]

I did these stteps
The problem is that every new sheet I try create in the
files based on Book.xlt in XLStart folder open in 100%
zoom.

 

[Tushar Mehta]

If you check Debra's instructions carefully, you'll note the name of
the file is sheet.xlt and not book.xlt. For more, you might want to
check the XL help topic 'Create a template' (w/o the quotes).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[JuliaKS]

Thanks, Debra & Tushar Mehta !
I tryed it before but it didn't work, so I thouth it is
misstake. Now I checked in TECHNET sheet.xlt keyword.
It still doesn't work in my computer but I will check it
on Monday again.