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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
Try adding this to the end of the code
activewindow.Zoom=75% -- HTH Bob Phillips (remove nothere from email address if mailing direct) "John" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
John wrote...
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 .... The macro recorder is your friend. ActiveWindow.Zoom = 75 That said, is your goal to prevent this user from saving the workbook with this particular worksheet's Zoom property set to 100 or to force the user to view this worksheet at 75 zoom? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
Thanks Bob
"Bob Phillips" wrote in message ... Try adding this to the end of the code activewindow.Zoom=75% -- HTH Bob Phillips (remove nothere from email address if mailing direct) "John" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
How could I prevent the change of the Zoom property Harlan?
"Harlan Grove" wrote in message ps.com... John wrote... 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 ... The macro recorder is your friend. ActiveWindow.Zoom = 75 That said, is your goal to prevent this user from saving the workbook with this particular worksheet's Zoom property set to 100 or to force the user to view this worksheet at 75 zoom? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set View to 75% upon Workbook open
"John" wrote...
How could I prevent the change of the Zoom property Harlan? .... Mine was a rhetorical question. Can't be done. While it may be possible to disable or remove the Zoom entry from the View menu, there are other ways to change the zoom setting. You could use the WorksheetSelectionChange event handler to reset the zoom to 75, but that'd only be annoying. Just let your users change the zoom setting as long as you have macros that'll reset it every time anyone opens the workbook. |
Reply |
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 |