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!
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!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
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.
ASKER
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 ...
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 topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Dave