Hiding an ActiveX button when hiding columns

[crobaseball]

I am putting several buttons into my spread sheet and would prefer to use ActiveX controls rather than form controls. But I also need to hide the buttons from the end user (controls are to update data and will be used by the person who maintains the workbook). When I go to hide the columns, the ActiveX button doesn't hide with it. On the other hand, if I use a Form Control Button instead, it does indeed disappear when I hide the columns. Is there any way to get the ActiveX button to hide when hiding the columns?

Thanks!

 

[BadgerRoad]

It is not a module. It goes in the Worksheet Change Event. Click on the worksheet tab, then View Code.
At the top left will be a dropdown tab that says General. Click the tab and select Worksheet under General.
On the right side is a tab that has several options one of which will be Selection Change. Click on Selection Change
That will insert the first line and the last line of the code I included above. Insert the rest of the code in between. It will execute every time there is a selection change on the worksheet.
Let me know if you have problems. You are welcome.

 

[axeaxeaxe]

There is actually a solution without VBA, see How to hide option button while hiding row in Excel?
Much better!