In the Macro name box, enter a name for the macro.
In the code window of the module, type the macro code that you want to use. Note: To create a macro from VBE, click Visual Basic. On the Developer tab, click Record Macro. Click Save and then close Excel Preferences. There are four settings for macros if the "Disable All Macros without Notification" radio button is selected, then the macro capabilities of Excel will be disabled. Under Customize the Ribbon, select Main Tabs and then check Developer. Click Popular, and then select the Show Developer tab in the Ribbon check box. Click the Microsoft Office Button Button image, and then click Excel Options. You should display the Developer tab or run in developer mode when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs.
Excel displays the same Trust Center Settings dialog box mentioned in the previous paragraph. When you install the new Office 2007 the first thing you want to do is show the developer tab. The add-in tab will appear only if an add-in uses the old commandbar interface rather than the ribbon UI. Please let me know what I need to do to get the add-in tab on the ribbon.
If you prefer, you can display the Developer tab in Excel and then click the Macro Security tool. I have MS Excel 2007 Professional Edition installed and I also loaded all the excel add-ins that came with the installation, but it does not give me the add-in tab. 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. 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).