Excel is a very flexible program. You can configure it to work just about any way you can imagine. For instance, you can create a macro, and then add it to a toolbar. To do this, follow these steps:
Figure 1. The Toolbars tab of the Customize dialog box.
Figure 2. The Commands tab of the Customize dialog box.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2926) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Variable arrays are used quite often in macros. If you use an array once in your macro and then need to reuse it for ...
Discover MoreDo your macros seem to be disabled on your new machine? It could be because of the security settings in Excel. Here's ...
Discover MoreIf you are using a macro to process a number of worksheets, you may have a need to know if the worksheet is empty or not. ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-03-16 02:26:03
christopher montilla
I work at a hospital as admittig clerk
I would like to know if I could increment a seriesof six numbers but beginning from the two inner digits in MS Excel
Ex. 210098
210198
210298 ...
only thetwo inner digits increment before the sixth digit increment when the two inner digits reach a count of 99
Ex. 219798
219898
219998
When it reaches 219998
the sixth digit will increment by 1
say, 210099
2013-12-31 14:23:08
awyatt
Ray,
Thanks for the heads-up. I'll get it fixed ASAP.
-Allen
2013-12-29 18:51:47
Jim Boyer
Good tip. I've worked on making some toolbars and macros in Excel 2003, but when I click on macros category, what shows up in the commands list is NOT the list of macros I have, but only two items: Custom menu item, custom button. How am I missing what you describe in step 5?
2013-12-29 13:30:04
Ray Austin
Allen,
At the start of this tip, I reckon the 1st word is the wrong Word !!
"Word is a very flexible program."
Ray
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments