Setting Default Zoom Level?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,
How can I set the default zoom level for all worksheets to a specific size
when ever a new sheet is opened? I've tried using this code, but it gives me
an error that says "Object variable or With block variable not set"

Sub Auto_Open()
ActiveWindow.Zoom = 85

End Sub

Thanks for any help.

Jim
 
Put this in the ThisWorkbook module. Then, even if someone has changed it,
each time the sheet is activated the zoom will change.

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
ActiveWindow.Zoom = 85
End Sub
 

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
setting all sheets in workbook to same zoom level? 2
Change Default Zoom 1
Chart zooming 2
How to set default zoom size for specific Word docs when opened? 1
Setting Zoom Level 2
Macro to format multiple worksheets 24
set default zoom for a user profile 1

Back
Top