I got it working...but now every spreadsheet I open has the Save/Save/Print
button disabled.

I put the "Private Sub Workbook_WindowActivate(ByVal Wn As Window)" in the
"This Workbook" item under Excel Objects...the EnableControls in a module in
that workbook only and assigned the _Click subs to the radio buttons.


"Greg Glynn" wrote:

The 2 SUBs (WorkBook_WindowActivate and Workbook_WindowDeactivate) get
added to the WORKBOOK module

The three _CLICK SUBs are associated with your Radio Buttons

The EnableControls SUB you can create as a module.


Greg