Microsoft Excel: Zoom Function ,Microsoft Excel.

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" & "c8"
Wrb.Sheets("Leraar").Cells(33, 8).Value = ExecuteExcel4Macro(Strg)
Wrb.Sheets("Leraar").Select
ActiveWindow.zoom = Wrb.Sheets("Leraar").Cells(33, 8).Value
Wrb.Sheet2.Select
ActiveWindow.zoom = Wrb.Sheets("Leraar").Cells(33, 8).Value
Wrb.Sheets("Opstarten").Select
ActiveWindow.zoom = Wrb.Sheets("Leraar").Cells(33, 8).Value

thanks in advance

Max

Keywords & Tags: zoom, function, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495179/

«« Prev - Next »» 0 helpful answers below.

Microsoft Excel Related Links

Microsoft Excel Hot Answers

ZOrder of two forms
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...
Zorder doing strange things
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...
ZOrder Behavior Changed in Excel 2007?
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...
Zoomed in files
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...
Zoombox
Dear All, I want to be able to open the zoombox on pressing shortcut (? a free one) for all cells in column R and S . Thanks³ Filip...

Microsoft Excel New questions

Zulu times
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...
Z-test using excel
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...
Z-Ordering supported?
Does Excel (2002, 2003) support Z-Ordering of Inserted Objects?...
ZOrder Behavior Changed in Excel 2007?
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...
Zooming in on a row
How can I click on a row (or cell) and that record is seen separately on a different worksheet....
Zoom via Macro for WorkSheet to activate?
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...
Zoom to fit the page width
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...
Zoom to 400%
Whenever a user opens an Excel Spreadsheet the sheet automatically zooms to 400%. This happens when the user is connected to a projector or second monitor. I have updated the display driver and downloaded all MS Office Updates. Nothing else seems to be having issues except Excel and Word. The on...
zoom problem with textboxes
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...
zoom out for printing in Excel 2002
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...

Microsoft Excel Related Categories

Microsoft Excel

(Microsoft Excel)Q&A: 'Zoom Function', widthout answer, Anyone resolve the question?...

Microsoft Excel: Zoom Function

Keywords & Tags: zoom, function, microsoft, excel

Microsoft Excel Related Links

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories

Microsoft Excel