For some reason, I got all excited about Windows desktop gadgets. That's kept me out of trouble for the past few weeks. I made two gadgets:

Office Recent Files - This gadget isplays a handy list of recent files for Excel, Word, and PowerPoint. Requires Office 2007 or Office 2010. I couldn't figure out how to read the Windows registry using Javascript, so I ended up using VBScript almost exclusively. I was surprised to see how nicely these two scripting languages work together.

SLAG - Simple Little Audio Gadget - I found a few music-playing gadgets, but I don't like any of them. So I made my own. It uses the Windows Media Player database. Written i

If you're running Vista or Windows 7, give them a try and let me know how they work. Gadgets aren't compiled, so you can see exactly how they are written.

You'll notice a new one: Excel Dashboards and Reports. It's really Mike Alexander's book but I contributed a few chapters and got listed as a co-author with the Data Pig.

The publisher and I still haven't decided if a new edition of Excel Charts will be added to the list.

From his "About" section:

I cut my Excel teeth on very early versions in the early 1990s. Before that I used Lotus123. I am completely self taught in the Excel arena and gained most of my knowledge while creating systems to run a large logistics company that I managed for 15 years. I've had hundreds of clients and successfully completed thousands of projects since.

Is he an Excel MVP? I missed the last two MVP Summits, and I hardly keep up with MVP stuff any more, so I don't know. If he's not, he should be.

Try this in Excel 2007...

First, make sure the Euro Currency Tools add-in is installed. Activate a worksheet that has a few formulas, and then run this macro:

Sub TestEuroTool()
  Dim WorkRange As Range
  On Error Resume Next
  Set WorkRange = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas, 23)
  Debug.Print WorkRange.Count 'formula cells
  Debug.Print Err.Number, Err.Source
End Sub 

Err.Number should be 0, since the sheet has formulas. But it's 9 (Subscript Out of Range), and the source of the error is Euro Tool (the name of the VBA project in EUROTOOL.XLAM) . At least a dozen PUP users have notified me of an error -- and uninstalling the Euro Currency Tools add-in fixes the problem.

It seems to be fixed in Excel 2010 beta.

• Hide rows: Ctrl+9
• Unhide rows: Ctrl+Shift+9
• Hide columns: Ctrl+0 (that's a zero)
• Unhide columns: Ctrl+Shift+0 (also a zer0)

They all work for me except the last one. It fails for Excel 2003, Excel 2007, and Excel 2010 (running Vista).

A bit of Googling tells me that others have the same problem. One theory is that the OS is intercepting that key combination before it gets to Excel.

Does Ctrl+Shift+0 work for you? If so, which OS and Excel version do you use? Note that to unhide columns, you must select a range of cells that includes columns to the left and to the right of the hidden columns.

It was a link to an ebook by someone named Francis J Hayes. Chandoo was upfront, and stated that he's an affiliate seller for the book.

I'm always interested in Excel secrets, so I took a look at the site.I was appalled. It looks exactly like any of thousands of scam sites on the Web, run by sleazy "experts" trying to make a quick buck from idiots. I normally don't like to such sites, but if you want to take a look, here it is: 101 Secrets of a Microsoft Excel Addict ebook.

Who knows? It might be the best Excel tips books in the world. But anyone with half a brain will click the Back button as soon as they see the site. It just reeks of sleaze.

Francis J Hayes might make a sale or two based on this post, but I posted it because I'm curious. Does that type of marketing actually appeal to Excel users?

By the way, who is Francis J Hayes? He claims to be an expert, but I couldn't find anything on the Web that didn't require payment or a subscription.

As Microsoft celebrates its 35th anniversary, I've decided to take an idiosyncratic and opinionated look at the best, worst and most notable moments, technologies, products, decisions and people in the company's history.

Excel gets only two mentions:

Smartest software bundling

Clearly the smartest software bundling move Microsoft ever made was combining Word, Excel and PowerPoint into Microsoft Office, first for the Mac in 1989 and then for Windows in 1990.

Microsoft Word, which Microsoft originally (internally) called Multi-Tool Word, was released in 1983 for MS-DOS, in 1985 for the Mac and in 1989 for Windows. Excel was launched in 1985 for the Mac and in 1987 for Windows. Also in 1987, Microsoft released PowerPoint for the Mac, essentially a version of an application called Presenter that was created by Forethought, a company Microsoft had purchased that year. In 1990, PowerPoint for Windows was released.

My cat enjoyed your book.

I should note that cats really like the later editions.

If you have any photos of my books out in the wild, send 'em my way, please.

It was arranged in categories, and each category had tasks below it, arrange in a row. Under each task name was date to indicate when the task was performed. Many of the date cells contained a cell comment to clarify (3,810 comments in all). Summary formulas were entered to count the dates. And each formula was hand-crafted because the layout was so haphazard.

I was very surprised to see such a poorly organized worksheet. But, after giving it some thought, this sort of thing is probably not at all unusual. The typical user, I think, probably starts entering data without giving the organization much thought. At first, it's easy makes sense. But after a few years of data entry, you end up with a complete mess.

I suggested that this person spend a day or two and copy/paste the data into a normalized table with four column headers: Category, Task, Date, and Comments. Data entry would be much easier, and the information in this table can be easily sorted, filtered, or summarized with a pivot table.

To a typical user, it probably seems very inefficient to repeat the category name and task name for every entry in the table. But it's actually the most efficient way to store data.

And that reminded me of a new shortcut I discovered last week:

• Ctrl+D makes a copy of an embedded chart (Excel 2007 and Excel 2010 only).

To help you remember, think "D for Duplicate." I couldn't find it in the Help system, and a cursory check of the Web leads me to suspect that I'm the first person in the world to discover this.

Before Excel 2007, the easiest way to copy a chart is to press Ctrl while you drag the chart with your mouse. That action was removed in Excel 2007, but Microsoft provided an even easier method -- and didn't even tell anyone about it!

Just a quick note to tell you how impressed I have been, for a very long time, with your Excel books. I bought one several years ago (maybe Excel Power Programming With VBA?) and, at the time, it put me ahead of all of my colleagues in terms of practical, ready to use knowledge about MS Excel.

Skip forward at least a decade and I had a current need to update my ss skills and went to Barnes & Noble to get some up-to-date resource technical materials. As I was scanning the available materials, my wife said "how can you ever manage to figure out which Excel book to pick?" At that moment in my scanning, I saw just "Walkenbach" and I pulled it out and replied "Right here, this guy is an Excel genius. I recall reading one of his earlier Excel books and it was just incredible." I think she thought I was kidding.

Well, I took Excel 2007 Bible home over the weekend and cracked it open this morning to get up to speed on charts. I wrapped up the 'Getting Started Making Charts' intro on charts and am just part way into 'Learning Advanced Charting' and I am very impressed! Your exceptionally clear writing style, focus on how to do the task at hand, easy transition from introductory to advanced materials are all just top-of-the-line.

So, I thank you, man, for putting out such a truly great product and I wish you the very best. I can't say enough good stuff!

Wishing you the best,
Greg S., NY

I'm glad you like it, Greg.

Excel has a macro facility, known as Excel 4 macros (XLM for short) that was the primary macro language prior to the introduction of VBA in Excel 5.0. Most people have long since migrated their Excel 4 macros to VBA; however, some Excel 4 macro capabilities were missing from VBA, which made this migration difficult.

In Excel 2010, one of our goals was to remove any remaining barriers that people had to complete the migration of Excel 4 macros to VBA.

The article lists quite a few things that, in the past, required an XLM macro. The most important new feature is the ability to provide argument descriptions for user-defined functions. These are the descriptions that appear in the Function Arguments dialog box.

I posted a new tip that demonstrates how to do this: User-Defined Function Argument Descriptions In Excel 2010.

Here's how it looked in 1997:

Click to enlarge, or try navigating it at archive.org.

I'd say my site design skills have improved over the years.

Mr. Walkenbach,

My name is Joe P. I'm a 22 year old college senior. I've been working on a co-op for about a year with a local company in Quality Assurance. When I started, the demands of the job went beyond my capabilities: they needed someone who could write Excel macros, and a lot of them. Determined to fulfill the role, I went to Barnes and Noble and picked up "Excel VBA Programming for Dummies."

That was about 9 months ago. Since then, I've learned the amazing things Excel can do thanks to your easy to follow guide. Not only has it expanded my capacity at work, but I've taken my Excel VBA skills and like to make fun spreadsheets in my spare time. I spent about 4 or 5 months writing a program that plays and analyzes the game of Craps in a little over 1 MB.

My time on co-op is almost up. When I leave, I plan to start up a consulting firm. I'm going to contract my services at building spreadsheets to small businesses in the area. Excel programming has become one of my favorite things to do, and I'm hoping I can find a market for my skills... I can't imagine a better way to make a living.

So I just wanted to send you a sincere thank you for writing your book, and wanted to let you know, I've put the information to great use, both professionally and personally.

Thanks for the kind words, Joe. When I started reading your email, I just assumed that the book you used was Excel Power Programming. Glad to hear that the For Dummies book also works.

It uses no macros. Unprotect the worksheet and try to figure out how it work. Some hints:

• Dynamic Charting with No VBA
• Combination of XY (Scatter) and Stacked Column chart types
• Marker Fill with picture files.
• Conditional Chart Formatting for chessboard style
• No IF() functions. Not even one. REPT() and boolean logic as alternative to IF() INDEX/MATCH

In my case, I used Excel about two hours ago to double-check a file that will be included on the CD that comes with my Excel 2010 Formulas book. The tech editor, Niek Otten, noticed a discrepancy between the text and a figure. So I had to check it. Niek's really good at tech editing books. I'm often amazed at the stuff he points out. Too bad it's such a low-paying job.

Before that, I received a PUP v7 upgrade request, and checked my PUP sales workbook to ensure that the person was eligible for an upgrade. She was. Yes, those upgrade requests are checked manually. Low-tech, but that's the best I can do.

So what's the last thing you did with Excel?

He suggested that "Jay" is short for J-Walk, and the cartoon is actually about me. It's unlikely because I have a different hairstyle, I don't have a briefcase, and I don't make house calls.

I wasn't familiar with Working Daze. I read some more, and Jay is a regular character in the strip, which has been around since at least 2001.

Assume that you have the VB Editor window open. You click Excel' minimize button to minimize the app to get it out of the way. Then you see the VB Editor window, and realize that there's no need for it to be open. So you close it -- and Excel's window pops back up!

Yeah, as far as annoyances go, it's a minor thing. But it's been going on since Excel 5. With every new version, I keep hoping it will be fixed, but it never is. I can't think of a single reason why closing the VB Editor window should restore Excel's window.

What little Excel quirks do you find annoying?

I also provide an OPML file that you can download.

What's an OPML file?

It's an XML file that contains feed details, and can be imported by most RSS aggregators. The net effect is that you can subscribe to all of these Excel blogs with just a few mouse clicks.

What's a RSS aggregator?

It's software that makes it very easy to keep up with dozens (or hundreds) of blogs. If you don't use an RSS aggregator, you really should. My favorite is Google Reader, a web-based aggregator (requires an account with Google).

To import these 44 Excel blog feeds (plus 20 additional feeds for the blogs that provide a comments feed) into Google Reader, first download the OPML file. Then navigate to Google Reader choose Manage Your Subscriptions, and then Import/Export. Browse for the OPML file, and the subscriptions will be added. Other RSS aggregators provide the same functionality.