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, Need to know is it possible to Zoom all sheets in a workbook at once, say have all appear at 200% or whatever, when I go to the Zoom control not just the sheet I am working on. Cheers, Andy....
I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75%...
i have office 2003. i created a file and accidently hit the scroll button which of course minimized the sheet. now when i open that file the zoom states 50% but is actually showing 100%. how do i reset the zoom to show correct size on sheet? this is the only sheet/file that this occures, all oth...
VBA newbie here (but learning quickly) I am trying to zoom to a set of columns. (say G:M) I am aware of: Columns ("G:M").Select ActiveWindow.Zoom = True But I am trying to do it without actually using the 'select' command. Let me explain: I have a worksheet that has the Worksheet_Selec...
I need to change Zulu time back 1 hour due to the daylight savings time. I have a format I need to follow, which is example ?P 04:45Z? Where the P needs to remain because it signifies proposed, and the Z needs to remain, because it signifies Zulu and the time 04:45 needs to be made 03:45 while p...
Hi, Not exactly an excel question but still posting here. I want to do z-test using Excel. I do have the analysis tool pak installed (along with Analysis tool-pak VBA). Being used to Canned software (The concerned tabulation software terms it as Z-Test for percentages) which tell me automaticall...
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...
I am creating a report using excel and i want to write/find a module that makes my report open up on anyones machine using excel 2000 look the same. I want it to adjust the zoom according to the users screen setting? Is this possible? I am not sure how to do it. If anyone knows could they help i...
I am creating a report using excel and i want to write/find a module thatmakes my report open up on anyones machine using excel 2000 look the same.I want it to adjust the zoom according to the users screen setting? Is thispossible? I am not sure how to do it. If anyone knows could they help i am...
Hi, I have more worksheet in the workboock. I wish the Application in another PC - wiht different Monitor-resolution to opening. However in the sam workSheet-largeness. A.) Automatlically? B.) Via macro (Button) in the defined Zoom, for all workSheet t activate? Have I any cance? Thank you very...
Hi,I have an excel workbook with multiple sheets. It is been used on differentcomputers and I would like my workbook to zoom always to right screen width.How can I do this?I have freezed panes on top of every sheet with a background picture thathas a width of 33,52 cm. I would like to have scree...
Hi, I have an excel workbook with multiple sheets. It is been used on different computers and I would like my workbook to zoom always to right screen width. How can I do this? I have freezed panes on top of every sheet with a background picture that has a width of 33,52 cm. I would like to have...