is there a code to set the default view size in Excel

  • Thread starter Thread starter Rebel
  • Start date Start date
R

Rebel

I want to set the view for a workbook at 85% for anyone that opens it. Is
there a code for that?
 
thanks.....

smartin said:
Place this in the Workbook code:

Private Sub Workbook_Open()
ActiveWindow.Zoom = 85
End Sub


Warn -- would be annoying to some users.
Click to expand...
 
You must log in or register to reply here.

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

Happy Birthday Muckshifter 6
Excel Protection 2
Default zoom 1
Error on opening Excel workbook 2
Error msg on opening Excel Workbook 1
How to open two Excel files in separate windows? 4
How to set the default format on excel? 3
How to reduce size of ms excel file-2003 1

Back
Top