Browse by Tags

Table Tools in Excel 2007

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 [...] Read More...

Published Fri, Nov 11 2008 1:43 PM by Daily Dose of Excel

Filed under: General, Excel12, Downloads

The Ultimate Steal

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 Read More...

Published Sat, Aug 08 2008 3:44 PM by Daily Dose of Excel

Filed under: General, Excel12

Add missing built-in commands to the QAT or Ribbon

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-in for the speech controls on his site this [...] Read More...

Published Sat, Aug 08 2008 10:05 AM by Daily Dose of Excel

Filed under: General, Excel12

Change built-in groups in the Ribbon

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 with RibbonX. And then we can [...] Read More...

Published Thu, Aug 08 2008 3:51 PM by Daily Dose of Excel

Filed under: General, Excel12, User Interface

Dealing with Ribbons and Menus - Avoiding Two Versions

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 to [...] Read More...

Published Thu, Jan 01 2008 2:01 PM by Daily Dose of Excel

Filed under: General, Excel12, CommandBars, Downloads

Macros are disabled when you open password protected workbooks

Hi all If you have the problem above in Excel 2007 read this page http://www.rondebruin.nl/password2007.htm It seems that not all machines have this problem. I have two Vista machines that will run the code without adding the DWORD. Very strange and I really like to know why. Ron de Bruin http://www.rondebruin.nl/tips.htm

Published Wed, Jan 01 2008 8:35 AM by Daily Dose of Excel

Filed under: General, Excel12

Page update: Copy a range from closed workbooks (ADO)

Hi all I update my ADO page today. http://www.rondebruin.nl/ado.htm The code is also working in Excel 2007 now (Excel 2000-2007). I use Late binding now to avoid private mails like "It is not working" When you use the Subfolder option in Example 7 it will loop through all files in all levels below the rootfolder. If you have problems or suggestions [...]

Published Sun, Dec 12 2007 11:12 AM by Daily Dose of Excel

Filed under: General, Excel12

Copy a customized QAT from one workbook to another (Add-in)

Hi all I create a small Excel add-in to copy a customized QAT from one workbook to another. http://www.rondebruin.nl/imageqat.htm#QAT Because it not use very common code I like to hear from you if you have problems or if there are there better ways to do it ? I hope a few of you can test it for me. You can find [...]

Published Thu, Nov 11 2007 4:36 PM by Daily Dose of Excel

Filed under: General, Excel12, Downloads, User Interface

Customize the images of the buttons in the QAT

Hi all I add a new page to my site with examples to change a button image of a button in the QAT for all workbooks or for one workbook. Making a QAT Add-in of the one workbook example seems a good way on this moment if you want to change the buttons images of your QAT. http://www.rondebruin.nl/imageqat.htm Suggestions or comments [...]

Published Tue, Nov 11 2007 1:15 PM by Daily Dose of Excel

Filed under: General, Excel12, User Interface

Syndication

Recent Posts

Tags

News

Archives

Table Tools in Excel 2007

The Ultimate Steal

Add missing built-in commands to the QAT or Ribbon

Change built-in groups in the Ribbon

Dealing with Ribbons and Menus - Avoiding Two Versions

Macros are disabled when you open password protected workbooks

Page update: Copy a range from closed workbooks (ADO)

Copy a customized QAT from one workbook to another (Add-in)

Customize the images of the buttons in the QAT