Apr 30, 2012 Hi Excel Experts! I am working on a Mac (OS10.6.8), Excel 2011 for MAC and I have opened up an Excel file, created in Excel 2007 on a PC. It is a Dashboard with multiple sheets which make up the background to the dashboard. The file contains a number of VB Macros which I have enabled. May 06, 2013 I am creating an Excel VBA project that applies several controls on a userform, including buttons, text box, frames, and combo boxes. Everything works fine except for the style of the controls. They look very much Windows style and I am wondering if there is a way to make the controls look like typical Mac style.

Vba Open Internet Explorer

-->

Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.

Syntax

expression.Zoom

expression A variable that represents a PageSetup object.

Remarks

This property applies only to worksheets.

If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.

All scaling retains the aspect ratio of the original document.

Example

This example scales Sheet1 by 150 percent when the worksheet is printed.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

-->

If you use the objects in other applications as part of your Visual Basic application, you may want to establish a reference to the object libraries of those applications. Before you can do that, you must first be sure that the application provides an object library.

To see if an application provides an object library

1. From the Tools menu, choose References to display the References dialog box.

2. The References dialog box shows all object libraries registered with the operating system. Scroll through the list for the application whose object library you want to reference. If the application isn't listed, you can use the Browse button to search for object libraries (*.olb and *.tlb) or executable files (*.exe and *.dll on Windows). References whose check boxes are selected are used by your project; those that aren't selected are not used, but can be added.

To add an object library reference to your project

Microsoft Internet Controls Vba Mac Free

• Select the object library reference in the Available References box in the References dialog box and choose OK. Your Visual Basic project now has a reference to the application's object library. If you open the Object Browser (press F2) and select the application's library, it displays the objects provided by the selected object library, as well as each object's methods and properties.

  In the Object Browser, you can select a class in the Classes box and select a method or property in the Members box. Use copy and paste to add the syntax to your code.

See also

Support and feedback

Microsoft Internet Controls Vba Mac Free

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.