| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable SAVE AS button from code
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 ............) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enable/disable button based on cell value | Excel Discussion (Misc queries) | |||
| Enable / Disable a button using a macro | Excel Programming | |||
| how to enable / disable customised button on toolbar | Excel Programming | |||
| How to enable/disable a button. | Excel Programming | |||
| Enable/Disable Button | Excel Programming | |||
Threaded Mode
