Is there a specific piece of code to remove a form/control button from a
worksheet? Have tried many things, none of them working! I don't mind if
it's just hidden actually, so long as it can't be seen by the end user once
the code has run its course

Try this

ActiveSheet.Shapes("yourbutton").Visible = False

Or

ActiveSheet.Shapes("yourbutton").Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Aaron Howe" wrote in message ...
Is there a specific piece of code to remove a form/control button from a
worksheet? Have tried many things, none of them working! I don't mind if
it's just hidden actually, so long as it can't be seen by the end user once
the code has run its course

for a commandbutton
Activesheet.Shapes("CommandButton1").Delete

or

Activesheet.Shapes("CommandButton1").Visible = False

for a button from the forms toolbar

Activesheet.Buttons("Button 1").Delete

or

Activesheet.buttons("button 1").Visible = False


If you are going to use the button again, I would hide and unhide it rather
than adding a new button each time.

--
Regards,
Tom Ogilvy


"Aaron Howe" wrote in message
...
Is there a specific piece of code to remove a form/control button from a
worksheet? Have tried many things, none of them working! I don't mind if
it's just hidden actually, so long as it can't be seen by the end user
once
the code has run its course

That worked, have never heard of the Shapes command before though!!
Thanks ;-)

"Tom Ogilvy" wrote:

for a commandbutton
Activesheet.Shapes("CommandButton1").Delete

or

Activesheet.Shapes("CommandButton1").Visible = False

for a button from the forms toolbar

Activesheet.Buttons("Button 1").Delete

or

Activesheet.buttons("button 1").Visible = False


If you are going to use the button again, I would hide and unhide it rather
than adding a new button each time.

--
Regards,
Tom Ogilvy


"Aaron Howe" wrote in message
...
Is there a specific piece of code to remove a form/control button from a
worksheet? Have tried many things, none of them working! I don't mind if
it's just hidden actually, so long as it can't be seen by the end user
once
the code has run its course