The first option on the View menu of the Office 2011 for Mac Visual Basic Editor (VBE) is the Code option, which is grayed out until you make at least one Code window visible in the VBE. A common way to open a new code window is to use Insert→Module. A module is like a new word processing document window — it’s blank. Hey there, Encountered this rather silly problem with Word 2011 on a friend's macbook pro. As a researcher, my friend uses a program called.
Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 You can set the properties for a Visual Basic project, and then set how you want to help protect the project. Do either of the following: Set the project properties. To begin, click Tools Macro Visual Basic Editor.
On the Tools menu, click VBAProject Properties (In Word, click Project Properties), and then click the General tab. In the Project Name box, enter the name that identifies your component in the registry of the Object Browser.
The project name is the name of the type library for your component. The type library, or TypeLib, contains the description of the objects and interfaces provided by your component. In the Project Description box, enter the description that will display in the Description pane at the bottom of the Object Browser.
In the Conditional Compilation Arguments box, enter the constant declarations used for conditional compilation. Help protect the project You can lock a project to help prevent someone from changing it or set a password to view the project properties. On the Tools menu, click VBAProject Properties, and then click the General tab (In Word, click Project Properties, and then click the Protection tab). To lock your Visual Basic project, select the Lock Project for Viewing check box. Under Password to View Project Properties, in the Password box, enter the password and then in the Confirm Password box, enter the password again.
![2011 2011](/uploads/1/2/5/6/125660436/684016298.png)
See solution in other versions of Excel:. Project Explorer The Visual Basic editor displays your VBA environment in Excel 2011: Next, let's take a few moments to analyze the various sections in the Visual Basic editor. In Excel 2011 for Mac, the Project Explorer is a window that can be accessed from the Visual Basic editor.
It is a hierarchical listing of the objects recognized by VBA. In this example, there are four Excel objects which represent each sheet and workbook in your Excel file - Sheet1, Sheet2, Sheet3, and ThisWorkbook. There is also one module called Module1.
The VBA code in Module1 can used anywhere in your spreadsheet. Whereas, the code within an Excel object is typically only used by that object. If the Project Explorer is not visible when you open the Visual Basic editor, you can make it visible by selecting Project Explorer under the View menu.