Hide/Display radio buttons

Hi no_Fate,

you made it extra complex to help you for various reasons :
1. Your worksheet is protected and there was no indication of the password in your code (fortunately the old "7-ZIP" trick worked)
2. There is no logic behind the names of the option buttons and their positions. For option Buttons 2 to Button 8 one could simply add "6" to button number to find the relevant row, but this would not work for buttons 13 and 14.

Therefore the macro looks slightly more complicated. As it uses the "worksheet change event" you will need to regard where to place it in VBE:

The macro must not be placed in a "normal" module but in the code module of the "Reference Guide" Sheet object. To create a worksheet Change event: use the Visual Basic Editor -> in the Project Explorer, double click on the appropriate sheet (under 'Microsoft Excel Objects' which is under the VBAProject/name of your workbook) -> in the Code window, select "Worksheet" from the left-side "General" drop-down menu and then select "Change" from the right-side "Declarations" drop-down menu. enter the below macro into the "Worksheet_Change" macro. Don't forget to adjust the Password!

Please Login or Register  to view this content.

Let me know if it works as expected!

Theo

Hi no_Fate,

the reason for the strange behavior is that the cells which are copied by your macro are outside of the accesible area. Rather than using the "copy" command you could add the following function to add text to clipboard:

Please Login or Register  to view this content.

The option Button Subs would need to be adjusted accordingly:

Please Login or Register  to view this content.

Please note that you forgot to add the "PW" after the protect command. While the sheet is still protected after the macro runs for the first time, the password will no longer be required. I recommend to change Sheet1.Protect to Sheet1.Protect PW

Let me know if this solves the issue

Theo