Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom Not Resizing
Worksheet "Scorecard" Zoom is manually set at 25%.
Running the below macro does not resize to 61%. Can someone help correct this code? Sub GoToScorecard() Sheets("Scorecard").Select Range("A1").Select ActiveWindow.Zoom = 61 End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom Not Resizing
I think your code is okay. It works for me.
-- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zoom Not Resizing
It worked fine for me. Do you have the workbook protected?
Does it raise an error. Tested in xl2000 -- Regards, Tom Ogilvy "Phil Hageman" wrote in message ... Worksheet "Scorecard" Zoom is manually set at 25%. Running the below macro does not resize to 61%. Can someone help correct this code? Sub GoToScorecard() Sheets("Scorecard").Select Range("A1").Select ActiveWindow.Zoom = 61 End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks.
Jim, Thanks for your reply. I closed the workbook,
reopened it, and the code works...go figure. Appreciate your time. -----Original Message----- I think your code is okay. It works for me. -- Jim Rech Excel MVP . |
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) | |||
Cell resizing | Excel Worksheet Functions | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
Resizing Charts | Excel Discussion (Misc queries) | |||
Resizing scroll box | Excel Discussion (Misc queries) |