Enable/Disable SAVE AS button from code

[Guest]

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.

 

[Jim Rech]

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

--
Jim
| 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.

 

[Guest]

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]

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
| 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="nameOfSubInWorkbookReturningEnabledState". Then when you
want
| > to change the enabled state invalidate the ribbon.
| >
| > --
| > Jim
| > | > | 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.
| >
| >
| >

 

[Guest]

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 ............)

 

[Jim Rech]

What should the type of my variable for the macro procedure
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/customuieditor.aspx

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

--
Jim
| 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 ............)

 

[Guest]

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

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/customuieditor.aspx

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

--
Jim
| 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 ............)