Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set zoom when file opened
David, here is one way, for one sheet
Private Sub Workbook_Open() Sheets("Sheet2").Select ActiveWindow.Zoom = 90 End Sub Or for all sheets Private Sub Workbook_Open() Application.ScreenUpdating = False Set A = ActiveSheet For Each Sheet In ThisWorkbook.Worksheets Sheet.Activate ActiveWindow.Zoom = 90 Next Sheet A.Activate Application.ScreenUpdating = True End Sub Put in this workbook code -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "david" wrote in message ... How can I write a macro that will set the zoom on the worksheet when the file is opened? Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
i zoom to 75% on Excel but returns to 100% reopening file | Excel Worksheet Functions | |||
View zoom slowing opening of the file | Excel Discussion (Misc queries) | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
zoom error when opening file | Excel Discussion (Misc queries) |