Disappearing Option Buttons

boojidad

New member
Joined
Aug 27, 2012
Messages
1
Reaction score
0
Points
0
I wasn't sure where I should post this, so hope this works. I have a worksheet with two sets of Option buttons. The buttons are assigned to one of two group names, and the VBA code for them is really simple (they hide or display certain columns.) The buttons work just fine when I first set them up, but when I close the file and then re-open it, only one set of buttons is visible. The other set disappears. They are not deleted - if I try to set them up again, I get a VBA error message telling me that I'm trying to establish a button that already exists - but I cannot "find" them anywhere. Two suggested solutions (setting Placement level to 3 and using VBA code to force display) have not been successful. Please help!
 
Top