Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to set the view for a workbook at 85% for anyone that opens it. Is
there a code for that? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to turn off Page Layout View as default view | New Users to Excel | |||
Default view of Excel to 75% | Excel Discussion (Misc queries) | |||
How do I set the default comment format and view in Excel | Excel Discussion (Misc queries) | |||
how can i set sheet1 as default view page in excel | Excel Worksheet Functions | |||
Default view when opening excel files | Excel Discussion (Misc queries) |