setting of screen zoom in excel

G

Guest

I need to have the Pre Set Zoom sizes of 85% and 65% in replacement of the
75% and 50% Excel Zoom Out Defaults.
Is it Possible? Thanks
SUNAN
 
G

Gord Dibben

I do not believe you can change the defaults in the Zoom dialog but you could
assign macros to buttons.

Sub Zoom_65()
ActiveWindow.Zoom = 65
End Sub

Or a on button toggle-switch to go forth and back.

Sub Zoom_65()
If ActiveWindow.Zoom = 65 Then
ActiveWindow.Zoom = 85
Else: ActiveWindow.Zoom = 65
End If
End Sub


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IPad remote 10
vba code to get an duse the value from a particular cell 3
Zoom 6
Zoomed in files 3
Default zoom 1
Excel 2007 Zoom and Page Break Preview 1
Zoom Display for whole workbook 3
Data Validation/In-Cell Dropdown Lists 1

Top