Hi All,
I am new to this forum. I am trying to figure out how to fix a form I created. The form uses VB ActiveX check boxes. The user clicks the check box pertaining to what information they need to fill out and the rows of data not relevant for them disappear (ie I click the blue checkbox and all the other colors information disappears). It works fine on PCs but I am now hearing that Mac users can't click the check boxes. A Google search turned up that ActiveX won't work on Mac. What are my options? Can I use form control check boxes to hide rows? If so, how?

Here is an example of the code I used originally when using ActiveX:

Private Sub Skincare_Click()
Range("A33:A37").EntireRow.Hidden = Skincare.Value
Range("A61:A62").EntireRow.Hidden = Skincare.Value
Range("A76:A86").EntireRow.Hidden = Skincare.Value
Range("A96:A98").EntireRow.Hidden = Skincare.Value
Range("A100:A102").EntireRow.Hidden = Skincare.Value
Range("A112:A115").EntireRow.Hidden = Skincare.Value
Range("A127:A129").EntireRow.Hidden = Skincare.Value
End Sub

Any help would be greatly appreciated!

Thank you,
Lacey