Spreadsheet rows can trigger context-sensitive events by using the "BeforeDoubleClick" event. In this simple exercise we illustrate how to drill-down from an executive report to the data below. This article assumes the reader has the Developer...
Read more »The Excel ribbon can be modified to suit a particular job. This exercise creates new menus that point users to specific sheets relevant to their task. In this article, we will introduce how to create customized menus in your Excel worksheet,...
Read more »Excel Templates are typically workbooks, with a reporting framework, often supported by functions. A templates (xltx) can be used over and again without polluting it with data. After population with data, a template workbook is saved as an xlsx,...
Read more »