Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ribbon issue when in cell edit mode
I have the most basic tab created for the Excel 2007 ribbon, xml at end along
with VBA After Excel starts, if I click my tab, my button is enabled and it works. After that, regardless of the state my current cell is in if I go back to my tab, my button is still enabled. However, if when I start Excel I immediately enter something into cell A1, then while still in edit mode I click my tab on the ribbon, I get a beep, and my button is not enabled. Furthermore, it will never become enabled short of disabling my add-in and reloading, or restarted Excel. Interestingly enough, if I removed the getEnabled callback, it works fine. However, if fails in the same way if I try to use a GetLabel callback. Obviously, the problem is moot if the user is not in edit mode when he clicks my tab. However, I can't control that. What can I do to restore my tab to functioning if and when this situation occurs? Ribbon XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" <ribbon <tabs <tab id="myTab" label="ThisTab" <group id="grp1" label="grp1" <button id="btn1" label="btn1Label" getEnabled="btn1Enabled" onAction="btn1CB"/ </group </tab </tabs </ribbon </customUI VBA from my xlam file, Module1: Option Explicit Private Sub Btn1CB(control As IRibbonControl) MsgBox "Btn1CB" End Sub Private Sub btn1Enabled(control As IRibbonControl, ByRef returnedVal) returnedVal = 1 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ribbon issue when in cell edit mode
Ron, excellent web-site you have. Lots of great stuff. Thanks for taking
the time to read my post. How can I report a bug, or ask a question, directly to the Microsoft Excel weenies? "Ron de Bruin" wrote: Hi N. L. Devotie Known problem that will not be fixed I bugged a problem with a dynamic menu -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "N. L. Devotie" <N. L. wrote in message ... I have the most basic tab created for the Excel 2007 ribbon, xml at end along with VBA After Excel starts, if I click my tab, my button is enabled and it works. After that, regardless of the state my current cell is in if I go back to my tab, my button is still enabled. However, if when I start Excel I immediately enter something into cell A1, then while still in edit mode I click my tab on the ribbon, I get a beep, and my button is not enabled. Furthermore, it will never become enabled short of disabling my add-in and reloading, or restarted Excel. Interestingly enough, if I removed the getEnabled callback, it works fine. However, if fails in the same way if I try to use a GetLabel callback. Obviously, the problem is moot if the user is not in edit mode when he clicks my tab. However, I can't control that. What can I do to restore my tab to functioning if and when this situation occurs? Ribbon XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" <ribbon <tabs <tab id="myTab" label="ThisTab" <group id="grp1" label="grp1" <button id="btn1" label="btn1Label" getEnabled="btn1Enabled" onAction="btn1CB"/ </group </tab </tabs </ribbon </customUI VBA from my xlam file, Module1: Option Explicit Private Sub Btn1CB(control As IRibbonControl) MsgBox "Btn1CB" End Sub Private Sub btn1Enabled(control As IRibbonControl, ByRef returnedVal) returnedVal = 1 End Sub . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 ribbon issue when in cell edit mode
I already report it in the beta groups and the answer was will not be fixed so
report it again will not help I think. Look for a link on this site http://msdn.microsoft.com/en-us/office/aa905515.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "N. L. Devotie" wrote in message ... Ron, excellent web-site you have. Lots of great stuff. Thanks for taking the time to read my post. How can I report a bug, or ask a question, directly to the Microsoft Excel weenies? "Ron de Bruin" wrote: Hi N. L. Devotie Known problem that will not be fixed I bugged a problem with a dynamic menu -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "N. L. Devotie" <N. L. wrote in message ... I have the most basic tab created for the Excel 2007 ribbon, xml at end along with VBA After Excel starts, if I click my tab, my button is enabled and it works. After that, regardless of the state my current cell is in if I go back to my tab, my button is still enabled. However, if when I start Excel I immediately enter something into cell A1, then while still in edit mode I click my tab on the ribbon, I get a beep, and my button is not enabled. Furthermore, it will never become enabled short of disabling my add-in and reloading, or restarted Excel. Interestingly enough, if I removed the getEnabled callback, it works fine. However, if fails in the same way if I try to use a GetLabel callback. Obviously, the problem is moot if the user is not in edit mode when he clicks my tab. However, I can't control that. What can I do to restore my tab to functioning if and when this situation occurs? Ribbon XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" <ribbon <tabs <tab id="myTab" label="ThisTab" <group id="grp1" label="grp1" <button id="btn1" label="btn1Label" getEnabled="btn1Enabled" onAction="btn1CB"/ </group </tab </tabs </ribbon </customUI VBA from my xlam file, Module1: Option Explicit Private Sub Btn1CB(control As IRibbonControl) MsgBox "Btn1CB" End Sub Private Sub btn1Enabled(control As IRibbonControl, ByRef returnedVal) returnedVal = 1 End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Ungrouping Excel Charts -- EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsberg? | Charts and Charting in Excel | |||
EXCEL 2007 COMPATIBILITY MODE ISSUE | Setting up and Configuration of Excel | |||
Excel 2007-starts in cell edit mode | Excel Discussion (Misc queries) | |||
VSTO and Excel-- End Cell Edit Mode Programmatically? | Excel Programming | |||
VSTO and Excel--End Cell Edit Mode? | Excel Programming |