| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom in on range
Im wishing to create a zoom button to zoom in on a preset range when clicked.
i have tried using the zoom command but this seems only to function with objects not ranges and i dont want to use best fit because resizing the cells is gonna cause one hell of a lot of probs!! Anyone got any ideas the range I want to zoom in on is A3:U31 i am hoping then to replace the zoom button with a zoom out button to reverse the process |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
zoom in on range
Try this simple macro:
Sub Macro1() ActiveWindow.Zoom = True End Sub -- Gary''s Student - gsnu200790 "Atishoo" wrote: Im wishing to create a zoom button to zoom in on a preset range when clicked. i have tried using the zoom command but this seems only to function with objects not ranges and i dont want to use best fit because resizing the cells is gonna cause one hell of a lot of probs!! Anyone got any ideas the range I want to zoom in on is A3:U31 i am hoping then to replace the zoom button with a zoom out button to reverse the process |
| 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) | |||
| zoom in &zoom out in VBA User Form | Excel Programming | |||
| prevent range names showing at low zoom values in excel | Excel Discussion (Misc queries) | |||
| Zoom a range without actually selecting it | Excel Programming | |||
| zoom to a range of cells. | Excel Programming | |||
Hybrid Mode
