The easiest way to do this would be to just to record a new macro. Start
recording, flip to whichever buttons you want to get rid of and delete them.
Once you're done, stop the macro and tidy up the code. You could even just
leave it leave it the way it is if you're not sure of what you're doing.

"Ant" wrote:

So...if the buttons are on multiple sheets should I use sheets array?

"davesexcel" wrote:


Sub clearbuttons()
Worksheets("Sheet2").Buttons.Delete

End Sub


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528019