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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - is there a code to set the default view size in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/232425-there-code-set-default-view-size-excel.html)

Rebel[_2_]

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

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

smartin

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.

Rebel[_2_]

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

thanks.....

"smartin" wrote:

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.

All times are GMT +1. The time now is 09:48 PM.