Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Excel 2010 Custom Ribbon - Question 2

In John Walkenbach's excellent Excel 2010 Power Programming with VBA (Chapter 21) there is an awesome sample of an .XLAM Add-In that has a Ribbon customisation.

Question: does anyone know if this will work?
Design a Custom Ribbon with VS2010 (in the Add-In) as a document-level customisation, where the user can add the Add-In as any other .XLAM Add-In - ie. without any need to do anything other than add the Add-In to Excel as you would any other .XLAM Add-In?

(I mean the 'User' can add the Add-In without any admin rights, register, IT dept involvement etc).

Thanks experts!
Microsoft Excel

Avatar of undefined
Last Comment
Avatar of royhsiao
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of dlmille
Flag of United States of America image

hindersaliva - what book (if any) did you get on VSTO and do you recommend it?

Avatar of hindersaliva
Flag of United Kingdom of Great Britain and Northern Ireland image


Hi Dave,
I got McGrath (VSTO For Mere Mortals) and recently got Dummies (as this is the only one post-VS2010). VBA to VSTO by Verschuuren print version came in the post yesterday from Germany. (it is out of print. but can buy PDF online. Got that. Not easy to read as many pages in landscape!!!)
Dummies - good Hello World intro. I was getting really confused with 'out of date' info on the net. This helped clear up as it is 'as of now'.
I don't have Eric Carter as it is C#.
Vershcuuren - compares VBA approach with VSTO. The way I want to learn. But again I don't want to invest too much on aspects superseded by VS2010. (Deployment for example, I think).
I think the big problem is ... there is not enough buzz on VSTO for authors and publishers to invest in books, updates. Wonder if you agree?

Maybe I should put what I learn on the net as tutorials in the coming months ...
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo