Microsoft Excel Category. - www.developertags.com

Can anyone tell me how to make a Zoom in/Zoom out control by usingexcel VBA user form?And also, when the picture is larger than thewindow, it will autocall the hand tool to move the picture(somethinglike ACDsee)Thank you....

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....

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...

Hi all,I am once again coming to the point where I've tried, and searched the forumfor what I think I need, but with no success...I need a code ( as below, with a difference), that will zoom to 75% when a(any) picturelink is selected(clicked on).The code below works, but I have a "roadmap" o...

Hi all, I am once again coming to the point where I've tried, and searched the forum for what I think I need, but with no success... I need a code ( as below, with a difference), that will zoom to 75% when a (any) picturelink is selected(clicked on). The code below works, but I have a "road...

Am looking for a macro which would increment zoom in and out by 10%instead of 25%Does any has the code.Thxs...

Am looking for a macro which would increment zoom in and out by 10% instead of 25% Does any has the code. Thxs...

Can anyone tell me how to make the picture can zoom in/zoom out, contract/expand picture using excel vba user form? is it possible to make it?...

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%)...

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...

Worksheet "Scorecard" Zoom is manually set at 25%. Running the below macro does not resize to 61%. Can someone help correct this code? Sub GoToScorecard() Sheets("Scorecard").Select Range("A1").Select ActiveWindow.Zoom = 61 End Sub...

I have the following code to "zoom" on a selection of one or more chosen cells.: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range ("B63:B65,G47:G48,G53,G64,G65,L58,L60:l65,M3")) Is Nothing Then ActiveWindow.Z...

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...

In the below code, I get a Run-time error:'1004', "Unable to set the Zoom property of the window class." The intent here is to insure the window is sized to 54% when the "Metrics" worksheet is selected by the macro. What do I need to do to fix this? Sub GoToMetric1() 'GoToMetricA1...

(Excel 2003 on WinXP with SP2)My workbook has 8 columns, of different widths, which precisely fit thewindow.There are - say - 20 rows of data.The zoom is set to 100%.If I copy all this data to a new book with the same amount of window spaceand set the same zoom and column settings, the result is...

(Excel 2003 on WinXP with SP2) My workbook has 8 columns, of different widths, which precisely fit the window. There are - say - 20 rows of data. The zoom is set to 100%. If I copy all this data to a new book with the same amount of window space and set the same zoom and column settings, the res...

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...

When viewing a speadsheet at 50% or 75%, the number 1 does not line up properly in the column with the other numbers. I am using arial 12 font. When it is full screen, it lines up perfectly. Unfortunately, I need to see the whole speadsheet at one time, hence the 50% or 75%. Any help would be gr...

Please you know why setting the Window.Zoom property canhave no effect on an activedocumenthost?Thnak you....

Please you know why setting the Window.Zoom property can have no effect on an activedocumenthost? Thnak you....

Microsoft Excel Q&A List

Microsoft Excel

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories

Microsoft Excel