Category: Excel

XLG Favourites Add-in Instructions

XLG Favourites Add-in Instructions This article contains instructions for the installation and usage of the XLG Favourites Add-in. To download this add-in, please visit the XLG Favourites Add-in page. Installation: Download and extract the package to your local PC or

Read More »

XLG Favourites Add-in

XLG Favourites This add-in was created to increase the functionality of Excel and address some shortcomings in the "Most Recently Used Files" listing. While we can increase the list to hold 9 items, I frequently use more than that many

Read More »

UseTemplate Add-in Instructions

UseTemplate Add-in Instructions This article contains instructions for the installation and usage of the UseTemplate Add-in. To download this add-in, please visit the UseTemplate Add-in page. Installation Download and extract the package to your local PC or the network drive

Read More »

UseTemplate Add-in

Templates Addin This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six

Read More »

Creating a Debugging Mode

I can't claim the original idea for this article. The concept actually comes from Professional Excel Development, but I developed the code, such as it is here, on my own. The reason for this was because I couldn't find it

Read More »

Maintaining Version and Build Information

Introduction: This article shows the method I use to maintain versions and builds in my applications and add-ins, which is to add properties to the ThisWorkbook module. These properties store their values in custom document properties, accessed from File|Properties|Custom, as

Read More »