I'm very please 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 your
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
So the other day I got a complaint from one of my users: "I really wish you'd fix the Excel tabbing issue in this file." Now I've sent a considerable amount of time training my users to enter data in
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
