I created Toggle Button (ActiveX Control) in excel and its working fine on my system and I am using Microsoft Operating System but its not working on MAC operation system. How do I fix the issue. Please help me.
None ActiveX-component won't with Mac.
#1 You could use 'normal' button from Developer. Those should work everywhere and You should add wanted code for it
#2 You could use a Shape like a Button, with code too.
In both ways, there could code many functionality. It depends - what do You really need from that button?
Now, I have created simple 2 different rectangle shapes and assigned the each shape with below code to hide and unhide the rows.
When I opened the file in MAC it wasn't working and all my hided sheets were un-hided and removed conditional formatting. Is there any different way should I open excel in MAC or enable in MAC. I am so confused with MAC.
>>> use code - tags <<<
Rows("25:47").EntireRow.Hidden = False
Rows("25:47").EntireRow.Hidden = True