Show button based on OptionButton being selected

Hi all,

I only have quite a basic knowledge of excel and am new to macros and buttons. I'd really appreciate some help with the following issue:

I have 3 option buttons on Sheet 3 (named OptionButton3, OptionButton4 and OptionButton5)
On sheet 4, there is a Button (a grey hyperlinked one) called 'Button 33'.
However, I only want Button 33 to appear when the OptionButton3 or OptionButton5 are selected.

So far, I have got as far as:

Please Login or Register  to view this content.

Written into the code for Sheet 3.

But this doesn't work - when I select OptionButton3 I get an error message ('Cannot run the macro "Tool Mock Up - pesticides 1.xlsm!OptionButton3_Click'. The macro may not be available in this workbook or all macros may be disabled'). Macros are enabled in the workbook.

Any help very much appreciated.

Moderator Note:

Pls use code tags around your code as per forum rules.

Hi

remove "Private" from the sub.

Please check this example file containing ActiveX controls: Opt and Cmd.xlsm

Hi,

The code is looking for the button on the worksheet with the name "Sheet5", if your sheet has a different name please adapt the code accordingly.

Alternatively you can use the Code-name of the sheet, that is the name displayed in the VBA project explorer before the bracket. e.g. Sheet5 (MyWorksheet) where "MyWorksheet" is the name displayed in the tab of excel.

Hi, one last quick question; in reality I will probably have several buttons on sheet 5, most of which will need to be visible/invisible based on the same OptionButton selections as CommandButton1.
I tried to modify the code adding an 'or' option, but have evidently not got it quite right:

Please Login or Register  to view this content.

I'd want to add CommandButton2, CommandButton3, and CommandButton4 to the above code.

I'd also like CommandButton 5 to instead be visible when OptionButton1 is FALSE and OptionButton2 is TRUE or OptionButton3 is TRUE.

If you can show me how/where to edit the code, I'd be very grateful. Many thanks.

Hi,

there are lots of possibilities to handle this, I'd do it like this where:
Op1 checked = Profile 1 --> cmd1-4 visible, cmd5 hidden
Op2 checked = Profile 2 --> cmd1-4 hidden, cmd5 visible
Op3 checked = Profile 3 --> all cmd's visible

Please Login or Register  to view this content.

New member here and i don't think that you start correctly choosing to ignore Moderators request.

I kindly asked for you to add code tags around your codes in your first post. 3 hours! later you post without code tags..Post# 8

It;s a warning now. Pls don't do this next time..

Also.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hi,

I assume that there is no ActiveX button named "CommandButton7" on the worksheet.