Tagged Questions
4
votes
1answer
566 views
Identify Pinned RecentFiles in (Excel 2007) VBA or other?
Is there a way, other than scanning the registry, to determine that a RecentFile object is pinned to the "Recent Documents" list? From VBA for preference, something that can live in an add-in.
...
3
votes
3answers
1k views
Better way to programmatically Lock/Disable multiple UI controls on Ribbon bar
I have been wondering, what would be the better way to implement Locking/Disabling a bunch of Ribbon UI controls by just a click?
Currently, my approach is kinda simple and basic:
private void ...
3
votes
2answers
934 views
How to disable Excel built-in RibbonButton?
Is it possible to set an excel 2010 built in RibbonButton to enabled=false from an excel VSTO Add-In?
I tried the following:
CommandBarControls ...
2
votes
3answers
1k views
How to remove the recent document history in Excel Ribbon using VBA
How to remove the recent document history in Excel Ribbon using VBA.
I am using the code below, but it doesn't seems to work.
Sub Button1_Click()
For i = 1 To Application.RecentFiles.Count - 1
...
2
votes
1answer
333 views
When running a Excel add-in, I always get a error, if my previous run ended in a breakpoint
I'm making a Ribbon add-in for the first time.
Sometimes I get this error/warning, when I run and start Excel from my VS10.
"Excel experienced a serious problem with the 'exceladdin1' add-in. If you ...
2
votes
3answers
2k views
How to get the Custom Task Pane Object on the Ribbon control Class
Developing a Excel vsto project, how could I handle the Custom Task Pane in the Class which is a Ribbon Control.
For example, I would like to show the Custom Task Pane when I click the button of the ...
2
votes
1answer
381 views
Insert WPF user controls in VSTO ribbons
I develop an Excel 2007 add-In using VS 2010 and existing WPF user controls. With the aid of ElementHost it is easy to integrate the controls in task panes and windows, but I found no way to integrate ...
2
votes
1answer
1k views
VBA code to add a basic ribbon in Excel 2010?
I have used products to write ribbons for Excel in C# (addin express) but I need to know how to produce a ribbon using vba. Would someone be able to provide me with some code that inserts an ...
2
votes
1answer
1k views
Office 2007/2010 Custom Ribbon UI How to Change TAB Color XML TAG
I'm using the Custom UI Editor for Office provided by Microsoft to create custom Ribbon Tab for Excel 2007. I didn't find how to change the color of a Ribbon.
Here a sample:
<customUI ...
2
votes
0answers
86 views
Excel Ribbon - Enable Filter button for protected worksheet
Using excel 2010 for protected sheets the auto filtering option on the Ribbon is greyed out. By however by right clicking I am still able to filter just fine despite the sheet being protected so this ...
1
vote
3answers
283 views
A second Excel Addin (Ribbon) installation appears when I open Exel, why?
I have made an Excel Add in (Ribbon).
When i run the .vsto and install it, i've one installation under Programs in Windows.
But, when I open my Excel program, another installation appears in the ...
1
vote
2answers
485 views
Can I create a custom excel document level ribbon without VS
I need to create a custom Excel 2010 ribbon (document level).
I have no Visual Studio, but have Visual C# 2010 express
If this is possible, please give me some gudelines.
1
vote
1answer
384 views
Inserting Images on the Custom UI Editor
I'm using the custom UI editor to upload images to a custom ribbon tab. I need the images to look like this:
but currently they are looking like this:
These images are directly from Microsoft ...
1
vote
1answer
2k views
Adding items to Ribbon dropdown using VB.NET
I am new to developing Excel VSTO solutions and need a little help on how to add further items to a dropdown control on the ribbon.
So far I have been able to create a number of items manually and ...
1
vote
1answer
5 views
Excel VBA - Intercept AddIn Ribbon Click
i would like to know if it is possible to intercept the event generated by the Ribbon Button of an Excel Addin. I'm able to access to the .xlam source but seems there is no code in it that intercept ...
