View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default is there a code to set the default view size in Excel

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


Place this in the Workbook code:

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


Warn -- would be annoying to some users.