Hi all
This week I create a small Add-in to add a few options to the contextual Table Tools tab.
This is a start and love to have feedback what you miss or like to see in a add-in like this.
This are now the options in the Add-in
1) Turn AutoFilter On or Off
2) Clear Filter of the [...]
I ran into a little problem with Excel 2007 this week. When I have an Excel 2003 add-in loaded in 2007, it exhibits some strange behavior when copying sheets. Namely, in certain circumstances the CodeName property of the sheet gets changed. I'm not sure what all those circumstances are, but I do...
I'm porting an application to Excel 2007 and thought I'd share some problems I've run into. First, there's FileSearch. I use FileSearch to read CustomDocumentProperties from closed Excel files. That way I can determine if the file is a part of my app and relevant to the context before...
Hi all
Great tip: Thanks to Dave Peterson
For the student (or families with students):
http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx
Ron de Bruin
http://www.rondebruin.nl/tips.htm
Hi all
I add this page to my site last week with a few examples to add missing controls
to the Quick Access Toolbar or Ribbon.
http://www.rondebruin.nl/notinribbon.htm
I am curious which missing built-in commands the readers of this blog have add to the QAT or Ribbon.
Tip: John WalkenBach posted a add...
Hi all
It is not possible to add to or remove controls from built-in groups in the Ribbon. For example, the
Format Painter button from the Home tab’s Clipboard group cannot be removed from this group.
But there is a way around this restriction.
We can hide a built-in group and then duplicate it...
Hi all
After creating and testing a lot of code to filter on normal and on Conditional Formatting colors
I came up with a nice and easy solution I think.
I made this page for Excel 2007
http://www.rondebruin.nl/colorfilter2007.htm
Suggestions are welcome
Ron de Bruin
http://www.rondebruin.nl/tips.htm...
If you can’t find it on the Ribbon, it’s on the Insert tab. Don’t ask me why. You’re welcome.
As I mentioned in a recent post, I’ve finally installed Excel 2007 (Office Ultimate, actually) on my home computer. I had it on a virtual machine back when it was in beta, but now it lives as a first-class citizen on my hard drive right next to Office 2000, Office XP, and Office 2003.
I’m...
Hi all
When you open your Excel 97-2003 file in Excel 2007, one that creates its own menus,
the first thing you notice is that you don’t see your menus. Where’d they go? Then you discover
them - shunted over on the Add-ins tab. Not exactly the ideal user interface.
How are your users going...