zoom

Hi All, In Excel - what area does the active window cover? If hide the tabs - scroll bar, tabs, ribbon etc - would the active window height and width be the same? The reason why i ask is because i want to set a zoom on my workbook open event is the window everywhere where the cells are...

Each time after I save as pdf using VBA, the zoom size is always more than 100%, how to set 100% always?

hi , I have one list box in excel, when i click, it shows all values. when i zoom in, then i can not see list box values Is there any way, if i zoom in still i can view all dropdown value from list box Heaps thanks in advance

Hey Everyone, I have been working on a VBA project for about the last 2 weeks, and I am confident enough in it to call it done (yay!). There is one thing, however, that is tripping me up... The macro will be run on a couple different computers around the office - which means it will be run on...

Rows in Excel keep expanding their height when I copy and paste om one lace to other in the same spreadsheet. I can roll the mouse wheel while holding down the Ctrl key to change the zoom and it goes back to the way it was. It is just irritating. It even happens when I save the spreadsheet using...

Here's my excel Europe map and there is some province that will named(and showed in map). And I have a problem, I want to hide those words when I zoom out, and it show name when I zoom in the map. Any way to do this?

Hi everybody, I created a number of charts as independent worksheet in a workbook, and I want to zoom them to the same magnification in the end. This should be fairly straight-forward using the code ActiveWindow.Zoom = 125 However, the charts always resizes to "fit-to-window" every time I...

Hi, I am really struggling to figure out how to move a picture to the bottom left of the windows screen in VBA. Would love it if someone could provide some insight (would also love to know if it is possible to keep it there (even if user scrolls or zooms the screen). Thanks, Geoff.

Hello I've created a spreadsheet which is a debt advisor for students, I am just having a problem where when I use a different zoom ratio, the formatting messes up. For example, the image here is when the zoom is at 70% and the image here is when the zoom is at 100%. The sheet at 70%...

Hello everyone, I am looking for some insight as to whats going on with my code. I am learning a lot, but its my current issue that driving me bonkers. Im here to ask for some help. I have created a user form for Excel "print" formatting and would like to give the user an option that would...

Hi all, I was wondering if anyone knew a way to change the default zoom level in Excel? I searched through the Forums and only found one similiar thread with an outdated link. I've read a bit about using VBA but my understanding was that VBA would only work in my current workbook. If possible...

Hello all! I have a macro that creates a PDF for each worksheet (see below) and it is working great. However, it saves each pdf at a different zoom level. I would like all the pdfs to open at a default zoom of 100%. Any help would be much appreciated! Option Explicit Dim ws As Worksheet...

Is there a way to find out how many pages the document will print, so that I can adjust the zoom level so that it only fits one page wide. I have tried fixing the page width to 1 page but the automatic page breaks dont allow me to display all the data I require on one page. I figure if i can...

Windows 8, Excel 2010; The cells AK11:AX11 are merged, I want to have have the worksheet zoom to a specified level (lets say 85%) when the range "AK11:AX11" is active. (when I click on the range "AK11:AX11" I want those cells to zoom to 85 percent). Can some one help me with this?

Hi, I'm looking for a code to have all the sheets in my workbook scroll together and adjust their zoom level. For example, if I zoom to 70% on Sheet 1 and scroll down to display cell J93 in the bottom left corner, I would like Sheet 2 to also be at 70% and have J93 be at the bottom left corner...

I am trying to make a "plotter" that will zoom to a selected chart with a macro button. I have tried a couple things but nothing seems to work. I can select the chart but not zoom to show the chart. What line of code will actually zoom to the chart once i have selected it? Thanks!

So I am new to VBA. I found tins of stuff through the forums out on the web and thus have learned a ton so thanks. I want 2 sheets in an excel model that are similiar (Income Stament and Balance Sheet) but are always a bit different. One might have 45 lines of data and the other one 60 and the...

My worksheet uses a closed ribbon, so how would I write a macro to open the Alt W, then Q to adjust the zoom level???:rolleyes: Thanx 4 any help out there!!!

Hello, I hope somebody can help: I've written some VBA code to create a chartobject and then save it as a GIF file, which is then loaded into a user form. This all works well and the image looks perfect - however, if I change the zoom of the active worksheet before running the code, the size...

Hey everybody! We recently converted to Office 2007 at work, and I'm struggling through the change! One thing that I've noticed in Excel 2007 (which doesn't happen to one of my coworkers) is that if my "Normal View" is zoomed (e.g. 75%, 150%) and I change to "Page Break Preview" view then back...