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

Excel 2007 ribbon issue when in cell edit mode
 

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

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

.

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

.