Hi all

FYI

A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac.
My idea is to go through all my webpages and see if I can make the VBA code also working in Excel 2011.

I start this problem page
http://www.rondebruin.nl/mac.htm

I also add VBA code examples last week to mail from Excel 2011 with Apple Mail and Outlook 2011.
If you have problems with Excel on a Mac post it here, maybe I can check it out and find a workeround for it.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi all

FYI, I add this page last weekend to my site :

Enable or Disable custom Ribbon buttons in Excel 2007-2010
http://www.rondebruin.nl/enable.htm

I also have a page for hiding and displaying :

Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm

If you have suggestions or good or bad comments let me know(I am no expert)

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi all

There is a common problem when you are working with the Ribbon with RibbonX and VBA.
The ribbon object (which is initialized when Excel loads your file) can loose its reference
to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations.
There is simply no easy built-in way to recover the handle to the Ribbon when there are problems
in or with your code. The only way to fix it is to close reopen your workbook, not a very user friendly way.

But MVP Rory Archibald came up with a great idea in a post in the MrExcel forum.
I created a example workbook based on Rory’s idea on the following page :

loss of state of the global IRibbonUI Ribbon object
http://www.rondebruin.nl/ribbonstate.htm

If you have suggestion or comments let me know so I can add it to the page

Ron de Bruin
http://www.rondebruin.nl/tips.htm

FYI

Excel MVP Dennis Wallentin allow me to publish his Lotus Notes examples on my site.
Great to have them online again so I can point Lotus Notes users to them when they mail me.

http://www.rondebruin.nl/notes.htm

Have a nice day

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi all

I update my GetImage page for Excel 2007-2010.
Thanks to Rob Bovey LoadPictureGDI (from Stephen Bullen) is also working now in Excel 2010 64 bit.

You can find the code in the example workbooks on the page below
http://www.rondebruin.nl/getimage.htm

FYI : Because of a bug in Word 2010 the code is not working in Word 2010 for ribbon controls.
If I have more info about this bug that I can share I will post it here.

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi all

I created this page this week :
http://www.rondebruin.nl/contextmenu.htm

I am curious about what developers think about the option in Excel 2010 to change contextmenus with RibbonX. Creating a dynamic menu in the Cell menu in Excel 2010 for example is easy to do because every time you right click on a cell it will run the getContent callback so it is very easy to change the menu.

Check out the three examples workbooks that you can download on that page for Excel 2010.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi all

I want to let you know that I upload a new version of Jim Rech’s button image add-in today.
You can find it in the “Find the names of the button images” section on my Ribbon page.
This great Add-in is working now in Excel 2007 and in Excel 2010.

While you there check out also my new file to find the control, group and Tab names in Excel 2010.

http://www.rondebruin.nl/ribbon.htm

Have a nice day