If you prefer, you can display the Developer tab in Excel and then click the Macro Security tool. Check the settings in the Trust Center (display the Excel Options dialog box, click Trust Center, and then click Trust Center Settings) to make sure that you allow macros. If you weren't asked about enabling macros when you opened the workbook, it could be because of the security level you have set on Excel itself. If you don't enable them, then the security setting on the workbook is set to a high enough level that the macros (and doing anything with the macros) are disabled. For instance, when you first open the workbook, you may be notified that it contains macros and asked if you want to enable them. There are any number of reasons why the options would not be available, but they all boil down to security settings for the workbook. She wonders why they are disabled and how she can make them available.
To add VBA scripting, double-click the check box to open Microsoft Visual Basic.Micky noted that when she opens a particular workbook in Excel and displays the Developer tab on the ribbon, some of the tools are disabled (Macros, Visual Basic Editor, Record Macro). If you're unfamiliar with the VBA values for a property, click the property name and press the F1 key to open the Visual Basic Help topic for that property. For an ActiveX Control check box, you can adjust the bounding box size and rotation, protection, alternate Web text, relative positioning and print appearance.Ĭlick "Properties" in the "Controls" group of the "Developer" tab or right-click the check box and choose "Properties" to open the Properties dialog box and enter the values you prefer for each feature. Right-click the check box and choose "Format Control" to open the Format Control dialog box.
To display the "Developer" tab, click the Microsoft Office Button, click the "Excel Options" button and click "Popular." Select the "Show Developer Tab in the Ribbon" check box and click "OK."Ĭlick the "Developer" tab, click "insert" and choose a check box from the "ActiveX Controls" section, and click the worksheet where you want to place the check box.You can adjust the check box's position by clicking anywhere within its bounding box and dragging it, or resize the bounding box by dragging its control points. Display the "Developer" tab if it doesn't already appear in Excel's ribbon.
0 kommentar(er)
