Hi,

Can I enable/disable SAVE AS option in OFFICE BUTTON from code ? I
disabled it when my add-in opens during the creation of my custom ribbon (not
from code).

thanks a lot in advance.

Instead of using the "enabled' attribute use
getEnabled="nameOfSubInWorkbookReturningEnabledSta te". Then when you want
to change the enabled state invalidate the ribbon.

--
Jim
"chris" wrote in message
...
| Hi,
|
| Can I enable/disable SAVE AS option in OFFICE BUTTON from code ? I
| disabled it when my add-in opens during the creation of my custom ribbon
(not
| from code).
|
| thanks a lot in advance.

The ribbon becomes invisible when my add-in will close, but SAVE AS remain
disabled. In previous office it was very easy to make it enabled, in 2007,
it's different.

"Jim Rech" wrote:

Instead of using the "enabled' attribute use
getEnabled="nameOfSubInWorkbookReturningEnabledSta te". Then when you want
to change the enabled state invalidate the ribbon.

--
Jim
"chris" wrote in message
...
| Hi,
|
| Can I enable/disable SAVE AS option in OFFICE BUTTON from code ? I
| disabled it when my add-in opens during the creation of my custom ribbon
(not
| from code).
|
| thanks a lot in advance.

but SAVE AS remain | disabled.

When you close a workbook or add-in that has embedded RibbonX, the ribbon
customizations should disappear, including disables. If you have an example
where this doesn't happen I'd like to see it as it would be a bug.

--
Jim
"chris" wrote in message
...
| The ribbon becomes invisible when my add-in will close, but SAVE AS remain
| disabled. In previous office it was very easy to make it enabled, in 2007,
| it's different.
|
| "Jim Rech" wrote:
|
| Instead of using the "enabled' attribute use
| getEnabled="nameOfSubInWorkbookReturningEnabledSta te". Then when you
want
| to change the enabled state invalidate the ribbon.
|
| --
| Jim
| "chris" wrote in message
| ...
| | Hi,
| |
| | Can I enable/disable SAVE AS option in OFFICE BUTTON from code ? I
| | disabled it when my add-in opens during the creation of my custom
ribbon
| (not
| | from code).
| |
| | thanks a lot in advance.
|
|
|

Sorry Jim, my mistake. I didn't know about this characteristic of embedded
Ribbons, disabling it would undo the changes done in Excel menus. It seems I
closed add-in and opened workbook also, that's why SAVE AS was still disabled.

I used the code below. What should the type of my variable for the macro
procedure MNU_show_Ufr_Save_AS2 ?

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<commands

<!-- Disable Save As in the Office button menu--
<command idMso="FileSaveAsMenu" enabled = "false"/
<command idMso="FileSaveAs" onAction="MNU_show_Ufr_Save_AS2" /

</commands


Public Sub MNU_show_Ufr_Save_AS2(ByVal control As ............)

What should the type of my variable for the macro procedure
MNU_show_Ufr_Save_AS2 ?

This is the callback signature for a button:

Sub MNU_show_Ufr_Save_AS2(control as IRibbonControl, ByRef cancelDefault)

End Sub

One way to get this is buried in this article:

http://msdn2.microsoft.com/en-us/library/aa722523.aspx

Another way that's easier is to use the Custom UI Editor:

http://openxmldeveloper.org/articles...muieditor.aspx

After you load your ribbonx into it just click the last button to generate
all its callbacks.

--
Jim
"chris" wrote in message
...
| Sorry Jim, my mistake. I didn't know about this characteristic of embedded
| Ribbons, disabling it would undo the changes done in Excel menus. It seems
I
| closed add-in and opened workbook also, that's why SAVE AS was still
disabled.
|
| I used the code below. What should the type of my variable for the macro
| procedure MNU_show_Ufr_Save_AS2 ?
|
| <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
| <commands
|
| <!-- Disable Save As in the Office button menu--
| <command idMso="FileSaveAsMenu" enabled = "false"/
| <command idMso="FileSaveAs" onAction="MNU_show_Ufr_Save_AS2" /
|
| </commands
|
|
| Public Sub MNU_show_Ufr_Save_AS2(ByVal control As ............)

Thanks a lot, Jim !!! for your help.

"Jim Rech" wrote:

What should the type of my variable for the macro procedure
MNU_show_Ufr_Save_AS2 ?

This is the callback signature for a button:

Sub MNU_show_Ufr_Save_AS2(control as IRibbonControl, ByRef cancelDefault)

End Sub

One way to get this is buried in this article:

http://msdn2.microsoft.com/en-us/library/aa722523.aspx

Another way that's easier is to use the Custom UI Editor:

http://openxmldeveloper.org/articles...muieditor.aspx

After you load your ribbonx into it just click the last button to generate
all its callbacks.

--
Jim
"chris" wrote in message
...
| Sorry Jim, my mistake. I didn't know about this characteristic of embedded
| Ribbons, disabling it would undo the changes done in Excel menus. It seems
I
| closed add-in and opened workbook also, that's why SAVE AS was still
disabled.
|
| I used the code below. What should the type of my variable for the macro
| procedure MNU_show_Ufr_Save_AS2 ?
|
| <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
| <commands
|
| <!-- Disable Save As in the Office button menu--
| <command idMso="FileSaveAsMenu" enabled = "false"/
| <command idMso="FileSaveAs" onAction="MNU_show_Ufr_Save_AS2" /
|
| </commands
|
|
| Public Sub MNU_show_Ufr_Save_AS2(ByVal control As ............)