Peltier Technical Services, Inc.
 

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | Peltier Tech Blog


Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 

Excel Dashboards

 

Books at Amazon.com

 

Excel and VBA Menus and Command Bars

Here are a few tricks I use for making menus and command bars for my Excel projects.


Floating Command Bar (zipped Excel file)
Floating Command Bar (text file)

This simple workbook contains the code to build a floating command bar when the file is opened, and delete it when it is closed. The command bar has two popup menus, each of which have two command buttons. No documentation supplied, just the file. Download either the complete Excel file, or the text file that contains just the VBA code you need.


Custom Drawing Command Bar.

Here is some code that generates a custom drawing command bar with my favorite built-in buttons. I originally wrote it for PowerPoint, but being part of the Office object model, it translated to Excel with only very minor adjustments. Both versions are shown.

Top of Page


Display FaceIDs

Display all 3000+ of Microsoft Office's built in button faces (screen by screen), so you can choose the right one for your special menu. Mouse over a button, and the ToolTip shows you its ID number. Click on one, and its image and number are stored in a worksheet for future reference.

 

 

Page copy protected against web site content infringement by Copyscape

 

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.


Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile