Question regarding an activex control button

[slim]

I created a button on worksheet that will run a macro. All I need to do is
to be able to hide the button when hiding the rows that the button is
located on.

For example, the button is contained on rows 1 & 2 of the sheet...I would
like to be able to hide these two rows, thereby hiding the actual button as
well. Currently, when I hide the two rows, the button will stay in the same
location..now on top of rows 3 & 4.

Is there any way this can be done? Otherwise, is there some other way to
achieve this goal?

Thanks again for everyone's help.

 

[David Fixemer]

Slim,

Used my VBA recorder to generate the following code:

ActiveSheet.OLEObjects.Add
ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=171, Top:=51.75,
Width:=46.5, Height:= _
22.5).Select
With Selection
.Placement = xlMoveAndSize
.PrintObject = True
End With


The key line is:

selection.placement = xlMoveAndSize

David Fixemer

 

[slim]

Thanks David..That did it!