Here's the scenario: I have two forms to display on the screen: Form1 and Form2. The Form2 is displayed after the user clicks a button on Form1 (which is already displayed). Form2 is automatically displayed in front of Form1. Both forms are loaded modeless (you can't load a second form...
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've created a data entry Excel file at work, and have placed severa text boxes on the sheet to let users enter notes. My usual scree resolution is 800X600, so this is the resolution I created th application in, and am having no problems at this resolution. However some users have their scr...
My work sheet only prints on the first half of the page width? Setup and margins don't seem to work so I can print larger. My worksheet prints out 4" wide and 2" deep. I want it to print the full page' ANy help is appreciated...
Adjusting the zoom level while viewing my spreadsheet appears to affect the formatting of the text in certain cells. For example, several of my cells have three lines of text, and when the zoom level is reduced, only the bottom two lines of text are visible. It appears as though the visible size...
I would like to know if it is possible to open a workshhet alway to the same same zoom level (i.e 94%) no matter if i am closing it to a different one (i.e 105%)...
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....
Hi all, I would like to use the zoom-function in VB. How can I accomplish this, when I want to use the zoom function for multiple sheets? here's an extract of my code. It gives an error, please provide help. Strg = "'" & filepath & "\[" & Filename & "]" _ & sheetname & "'!" & "r33...
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...