Change Default Zoom

  • Thread starter Thread starter geek_girl
  • Start date Start date
G

geek_girl

Hi Guys,

I'm trying to create a public procedure to change the default zoom of
spreadsheets. I tried the following however it returns the object not
supported error:

Public Sub AutoOpen()
ActiveWindow.ActivePane.View.Zoom.Percentage = 200
End Sub

Your help will be greatfully received.

Cheers,

Amie
 

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

Making a macro "auto open"` 2
Set document zoom to 90% 6
Setting Default Zoom Level? 1
How to change default zoom Excel 2007 10
change default zoom for new documents 3
formatting is incorrect when viewing in different zoom except for 75% 3
Changing the default theme 1
Zoom Box Font 2

Back
Top