I'm very pleased to be able to share a Chapter from my new book, RibbonX - Customizing the Office 2007 Ribbon. This chapter discusses the comboBox and dropDown RibbonX elements in detail. From using Microsoft's built in elements to creating
I have now posted a copy of Chapter 7 of the RibbonX book. You can find it here. 🙂
I'm very pleased that Wiley Publishing has encouraged me to post an excerpt from our new book RibbonX - Customizing the Office 2007 Ribbon, which can now be found at Amazon.com and other online retailers. Chapter 2 of the book
Introduction: This article contains code that can be used to print worksheets or entire workbooks to a PDF file, using Microsoft's free Save as PDF or XPS add-in for Office 2007. These routines will NOT work in versions of Office
One of the big things that Office 2007 was supposed to bring was the ability to save to a PDF file, without getting extra software. Somewhere along the line, they decided to make this feature an Add-in, which can be
A couple of days ago, Johan asked how it was possible to write almost 700 pages on the Ribbon... I figured that this was probably as good an opportunity to tell what is in the book (RibbonX - Customizing the
One of the big tools missing from my coding arsenal has been a place to store code that I've written. Jon Peltier claims that one of his most important tools for developing is Google, and I can't argue with that.Â
Introduction: There are times when you may need to force your users to enable macros to work with your files. Maybe you've programmed some special functions to work with your file, for example. Unfortunately, Office's security settings can get in
How would you finish that sentence? I'm going to be teaching a beginning Excel course in the middle of September. Because many of the users just received their first computers about a year ago, with no formal training, we're starting
Most of us, when we start dabbling with Excel macros, probably take the following steps: Record code Begin to make minor edits to the code Eventually learn about loops and start using them everywhere Learn that loops are "expensive" and
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
