logo ASAP Utilities

Answered Questions (FAQ)

If you have a question or experience a problem with ASAP Utilities then please verify if there is already an answer to your question or solution for you problem in our list of frequently answered questions.

Priority support for clients

If you can't find the answer on our website then please contact us.

Version history

A history of the various updates and improvements throughout the years

How it makes YOU rock in Excel

These short tutorials show you how to benefit from the tools in ASAP Utilities and are guaranteed to save you time and speed up your work in Excel.

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of our excel add-in

Uninstall

How to (temporary) uninstall ASAP Utilities.

Bug report

If you have found a bug first make sure you are using the most recent version. If that is the case go to our bug-report page

Debug information

In some cases you will be asked by our support-team to turn on the debug-mode to help solve specific problems.

Links

Links to interesting websites

Excel Books

The best books on Excel. Whether you want to learn Excel, write better formula's, learn how to use macros or write professionals applications in Excel these are the best books
This is an old article that has been archived.

Excel 2007: Customizing the Quick Access Toolbar with all commands causes 2 empty popups

Published: June 5, 2009 (latest revision August 31, 2021)
reference id: QA0208
This is an old article that has been archived.

Question

In (only) Excel 2007, when you customize the ribbon, you could get to see 2 empty visual basic popups:
customize-quick-access-toolbar-empty-popup.png

This only happens when you customize the Quick Access Toolbar and either choose commands from "All Commands" or when you choose commands from the "ASAP Utilities Tab". As soon as you select the option you may get numerous 2 empty Microsoft Visual Basic popups. After this you see a lot of buttons that have button that has the text "<< No label >>".
customize-quick-access-toolbar-all-commands.png
customize-quick-access-toolbar-all-commands-error.png

Answer

Unfortunately this is a bug in (only) Excel 2007.
The workaround is to first first select the ASAP Utilities tab and then customize the ribbon in Excel 2007.
Also, if you use ASAP Utilities version 5.0 or older, then please upgrade to the latest version.

Technical details

ASAP Utilities uses dynamic labels (getLabel) and screentips for the buttons and dropdown menus on the ribbon menu so that it can be updated for example when the language is changed.
Although we do this exactly as documented by Microsoft this causes empty Visual Basic popups when you want to customize the ribbon (quick access toolbar, qat) and choose "all commands". The same goes for the getImage and getScreentip tags. Unfortunately there is no way to trap or customize this behavior.

The workaround when using Excel 2007 is to first click on the the ASAP Utilities tab and then customize the ribbon, then you do not get the popups.
We hope that MS will fix this in the next service pack of Excel 2007. However, Office service pack 3 unfortunately still has this bug and we're afraid that MS will never fix this bug in Excel 2007.
In Office 2010 and later this bug is fixed by Microsoft and you don't get the empty popups.

Additional keywords:
blank Microsoft Visual Basic error





« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years