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

R

Rebel

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

smartin

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

Place this in the Workbook code:

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


Warn -- would be annoying to some users.
 
R

Rebel

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...
 
Top