No control for option buttons, invisible macro??

  • Thread starter Thread starter Steve
  • Start date Start date
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.
 
Ah, never mind, found the code in the sheet where the buttons reside
(not in a module). Should have searched this group first, a search on
"hidden macros" did the trick. Thanks anyway.
 
Is the worksheet protected? If so, this might answer the unable to select
property.

also you can try running code like

Sub AA()
for each obj in Activesheet.OleObjects
debug.print typename(obj.Object), obj.name
Next
End Sub


If you don't get anything from that, then try

Sub AB()
for shp in Activesheet.Shapes
debug.print shp.name
next
End sub

It might give you some insights into what you have. I have found that
activex controls added with code can often exhibit this type of behavior.
(although they can usually be selected)
 
Back
Top