VBA works on MS Excel 2013 but not working on MAC Excel 2011

[nicholasyu]

Hello Mr.Excel,

I wrote a hide rows VBA on Excel 2013 (see the code below), it is working fine. But when I opened in MAC Excel 2011 the button is not working (it become static buttons). I have the button as "form control"

Private Sub OptionButton_NA_No_Click()
Sheet1.Range("90:120").EntireRow.Hidden = True
Sheet5.Range("2:33").EntireRow.Hidden = True
End Sub

 

[Andrew Poulsom]

Welcome to MrExcel.

Given your VBA code it looks like you have an ActiveX control rather than a Form Control.

 

[nicholasyu]

Welcome to MrExcel.

Given your VBA code it looks like you have an ActiveX control rather than a Form Control.

Thanks for the quick reply!
I am new to Excel VBA Code. The VBA code I have it is under Module. How I change it to "form Control" or Do you have an example vba quote for hidden rows for "form Control"?

 

[nicholasyu]

Thanks for the quick reply!
I am new to Excel VBA Code. The VBA code I have it is under Module. How I change it to "form Control" or Do you have an example vba quote for hidden rows for "form Control"?

Okay i fixed it.
The reason it was not working because I have Group Box (Form Control) on top of my option button, it was working fine in Excel but it doesn't work in Mac 2011. So i have to group my Group box with my option button together and it works!