Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
I have the following code which runs upon opening my workbook. How would I
include to View of this "Current Week" to 75% upon open also? I have a user that changes it to 100% each time they use it Thanks Private Sub Workbook_Open() Application.ScreenUpdating = False Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets sh.Select Application.Goto Reference:=sh.Range("a1"), Scroll:=True Next sh ThisWorkbook.Sheets("Current Week").Select Application.ScreenUpdating = True Range("C6").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links only update when external workbook is open | Excel Worksheet Functions | |||
Open A Locked Workbook | Excel Worksheet Functions | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
Can't open workbook (in Excel 2000) | Excel Discussion (Misc queries) | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel |