Author: Ken Puls

Activating a Tab on the Ribbon

If you're working with the Office 2007 Ribbon, you may have come to the conclusion that there are areas of, the RibbonX object model which are kind of weak. One of the areas that lacks in the RibbonX API is

Read More »

size Attributes in dynamicMenu

A user asked a question in Experts Exchange asking if it was possible to use a dynamicMenu in the officeMenu.  The answer is that yes, you can, but this person couldn't get it to work. The issue appears to be

Read More »

Windows Mobile Smartphone thoughts

I still love my phone, but there are a couple of things I'd like to see... We're activating the feature which requires our users to put in a password to unlock the phone.  In addition, we'll be activating automatic wipe

Read More »

Office Mobile

With my new Windows Mobile phone came Office Mobile, including Excel Mobile version 6.1.  (I always thought it was Pocket Office and Pocket Excel, but my phone says otherwise.) Being an Excel guy, I was kind of excited to see

Read More »

Windows Mobile Smartphone

As of this afternoon, we've finally got our new Windows Mobile Smartphones hooked up to our Exchange server.  🙂 This is really cool, as I no longer have to plug it in to sync up the device with my Outlook

Read More »

Marking cells without dependents

I tripped on this in a forum today... The user wanted to create a message for all cells that did not have any cells dependent on their target.  The set about doing this by using the Trace Dependents tool through

Read More »

Using Named Range to Refer to Cell Above

The last couple of times I've taught, I've received a question about how to deal with the following scenario: You have a table of data, say in A1:A10 In A11, you have the following formula:  =sum(A1:A10) Someone highlights row A11,

Read More »

Custom Number Formats

Over the last couple of weeks, I've led 3 sessions of my course on "Building Spreadsheets That Last". It's a course that focuses on good design practices in Excel, making things easy and intuitive for users, and generally teaches skills

Read More »

Excel Videos

I just recently taught my course on "Building Spreadsheets That Last". In it, I actually show a video that was written by Ross on Workbook Structure protection. I like Ross's video, as it shows some interesting tricks with the features.

Read More »