setting of screen zoom in excel

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

vba code to get an duse the value from a particular cell 3
IPad remote 10
Zoom 6
Zoomed in files 3
Default zoom 1
logitech mouse wheel in Excel zooming rather than scrolling 1
Set my Zoom to 75% on opening new Workbook 1
Data Validation/In-Cell Dropdown Lists 1

Back
Top