What formula would I use to hide multiple objects more than ten), on a worksheet using a command button or an option button, and make them re-appear immediately instead of cascading.

Hi Robert,

Thanks for your question. But could you elaborate a bit further? There is no Excel function/formula for hiding objects.

Can you tell me what are you trying to create, e.g. a userform?

Regards,

Katie Woo
Microsoft Certified Trainer

Katie,


What I am trying to do is create a worksheet with multiple objects on it. When the worksheet is activated only selected buttons are visible and enabled or bisible and unabled. When a command button is selected other command buttons and option buttons become enabled and visible. What I need is for theses objects to appear all at once and when a second command button is selected the original objects return to their original state of not being visible or enabled.

I have created an Array statement which appears to work but still involves a lot of code.

Hi Robet

On the Worlsheets Activate Event you make the required buttons or other objects visible and all other buttons invisible. eg:

Private Sub Worksheet_Activate()

cmdButton1.Visible = True
cmdButton2.Visible = True

cmdButton3.Visible = False

optOption1.Visible = True
optOption2.Visible = False

End Sub

The above open the worksheet and shows only buttons 1 and 2.

The code below makes the second Opotion box visible andhides the secons button:

Private Sub optOption1_Click()

cmdButton1.Visible = True
cmdButton2.Visible = False

cmdButton3.Visible = False

optOption1.Visible = True
optOption2.Visible = True

End Sub

Hope this helps

Carlos