S
Steve
I have a spreadsheet with what appear to be five option buttons on one
of the sheets. However, when I try to select them for editing format
control, etc. (not just click on them -- that works), I cannot do it.
Normally one can right-click on the button and get the menu with Format
Control, Assign Macro, etc., but not in this case. And if I select the
Select Objects arrow from the Drawing toolbar and try to select these
buttons, nothing. Also, when I click on one of them, a button appears
that when clicked obviously runs a macro (it unhides some sheets), but
this button too appears to be inaccessible to editing, etc. Finally, I
cannot see any of the macros assigned to these objects -- the one that
generates the button when one of the option buttons is clicked, nor the
one that unhides the sheets when the generated button is clicked. Any
help is greatly appreciated.
of the sheets. However, when I try to select them for editing format
control, etc. (not just click on them -- that works), I cannot do it.
Normally one can right-click on the button and get the menu with Format
Control, Assign Macro, etc., but not in this case. And if I select the
Select Objects arrow from the Drawing toolbar and try to select these
buttons, nothing. Also, when I click on one of them, a button appears
that when clicked obviously runs a macro (it unhides some sheets), but
this button too appears to be inaccessible to editing, etc. Finally, I
cannot see any of the macros assigned to these objects -- the one that
generates the button when one of the option buttons is clicked, nor the
one that unhides the sheets when the generated button is clicked. Any
help is greatly appreciated.