Hiding ActiveX controls

[Darth269]

I want to hide 2 ActiveX buttons, if the cell before them is empty... Buttons are TEST13 and HOUSE13, and the cell to be blank is B16.

I guess I may not even need VBA for this, but i'm not sure how to do this with any method. Also note : I don't want to hide the row, just the buttons.

Thanks folks...

[Andy Pope]

right click sheet table and add code.
Change sheet code name to make your workbook

Please Login or Register  to view this content.

[royUK]

Try this, change the cell references & button names.

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

TDQ Andy!!!!!

[Darth269]

Sorry for the late reply...But that worked thanks.