Can anybody explain what's going on here ? Put two listboxes and two commandbuttons on a form and partially overlap the two listboxes. The code below should alternately bring to the front and then to the rear Listbox2. Private Sub CommandButton1_Click() ListBox2.ZOrder (0) End Sub Private S...
Argh! Form controls now *always* appear on top of shape/drawing objects. What's up with that? Prior versions of Excel allows you to send Form controls behind shape objects by right clicking on them and choosing "Order->Send to back". Ok, so you're probably asking "why would you ever...
Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like t...
I have made a budgeting system that contains 20 sheets. When the workbook is opened It cycles though each sheet to collect Current data already on each sheet. The probelm I have run into is that depending on the size of the monitor the workbook is opened with, manual zooming is required to get a...
In Word, to take the page width zoom setting and make it part of the tool bar I used Tools | Custm,ize, select the All Commands category on the commands tab, then scroll down to ViewZoomPage Width and drag it to a toolbar. Can this be done in Excel? Much thanks. -- eric...
Can anyone tell me how to make a Zoom in/Zoom out control by using excel VBA user form?And also, when the picture is larger than the window, it will autocall the hand tool to move the picture(something like ACDsee) Thank you....
I have a large excel document consisting of multiple pages pulling info from a dde server. I am trying to zoom the display, which I have always beeen abe to do. Today the zoom button is greyed out. I checked the protection and the document is not protected. Any ideas? Thanks...
When opening an Excel file it zooms the font only to 200% (very large). The menus are all regular size, and going into the view menu and changing the view to something different resizes the font to its correct size. I can then change the view to what is needed. Any suggestions?...
Anyone know what would cause the zoom button in preview mode to be disabled and the preview unchangeable? I am able to open the document, edit it but when I print preview it, I am unable to zoom to any resolution as the zoom button is diabled....
I'm looking at trying to have the column size automatically adjust to fit when a user changes the zoom level. I have my workbook doing this now upon open but I'm not sure how to accomplish this when they change the zoom level. thanks...
I am having a problem with the zoom function in Excel. When I enter a series of numbers in a column using Arial 10, the numbers line up properly. When I reduce the zoom to 75%, the propotional spacing appears to run amuck so that the columns of numbers no longer line up properly. I am using a De...
I have not really looked in to it, but is there anyway to use files that are in a zip file or other type of *.data file (EXT would only hide the format) and use them in Excel? I am interested in zipping up a folder of 700+ picture files that are used with one of my programs. I would like to get...
I have several excel files that I zip together. Recently another user added, and then removed, security to the excel files. Now, when I zip them all together, instead of being 3 or 4 mb, the zipped file is 13 mb. I need to know how I can reduce the zip file back to the original size, if anyone c...