rjusa
05-02-2014, 03:43 AM
I have written an add-in that works with XL 2000 and forward…to a point. When a workbook (2000-2003) is launched, the standard MS Save & Save As… functions are disabled (i.e., grayed out) and saves are accomplished through menu selections from the add-in menu. For XL 2007+ grayed out not true, so I wrote the following which works to disable standard Save/Save As
11633
In the add-in Utility section the user can turn back on (XL 2000-2003) the standard MS Save & Save As…functions. My question is how to incorporate the ability to turn back on in 2007+? Obviously if I edit my code to “enabled=true” on open of workbook, both are now enabled.
Also, how does one disable (gray out) the Save disc icon in the quick access bar? Thank you for reading this, hope someone can help.
11633
In the add-in Utility section the user can turn back on (XL 2000-2003) the standard MS Save & Save As…functions. My question is how to incorporate the ability to turn back on in 2007+? Obviously if I edit my code to “enabled=true” on open of workbook, both are now enabled.
Also, how does one disable (gray out) the Save disc icon in the quick access bar? Thank you for reading this, hope someone can help.