word-excel-access-help.com logo
Excel Macros
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel Macros
Additional Resources



Excel Macros



Excel Macros | Microsoft Excel XP | Page 5

Microsoft Excel XP logo
Learn step-by-step how to record, run, stop and delete Excel macros. Also learn how to assign an Excel macro to a button, menu or a shortcut key command.

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task.

For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.

No matter what you choose to do, Excel macros can make your daily tasks much easier!

Excel Office Helper What's on this page...
Create a Macro
...change the security level
Run a Macro
Edit a Macro
Delete a Macro

Assign a Macro to a Toolbar Button
Delete an Assigned Macro Toolbar Button
Assign a Macro to a Menu
Delete an Assigned Macro Menu

Assign A Macro To A Menu

You can assign a macro to a specific spot on any menu in the menu bar. This way the macro will be easily accessible from any menu you choose.

To assign an Excel macros to a menu, follow these steps:

1. Choose "Tools" ► "Customize" from the menu bar, and click the "Commands" tab.
   
  Excel Macros: Customize dialog box
   
2. From the "Categories" list box, scroll down and click on "Macros".

Notice that the options in the "Commands" list box changes.
   
3. Click-and-drag the "Custom Menu Item" icon from the "Commands" list to any place on any menu where you want the macro to appear.
   
4. Now you need to assign a macro to this new menu item. Once you've dragged the new menu item to a menu, you'll notice that the "Modify Selection" button is enabled.

Click the "Modify Selection" button and click on "Assign Macro".
   
5. Select the name of the macro that you want to assign to this new toolbar button.
   
6. Click "OK"
   
7. Click the "Modify Selection" button and click on "Name".
   
8. Type a name which will appear in the menu and press Enter.
   
9.  Click "Close".
   
Excel Office Helper "Modify Selection"

From this button option you can change the assigned macro's menu name, text and many other options.

Remove An Assigned Macro Menu

You can add as many menu items to any menu as you like, then you can remove these menu items just as easily.

Simply click "Tools" ► "Customize" from the menu bar.

Now you can click-and-drag the menu item that you want to remove from the menu bar.
 
Back to Top
 
See also... Create a Macro | Run a Macro | Edit a Macro | Delete a Macro
Assign a toolbar button to a Macro
 
Return to Excel XP from Excel Macros
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter