Deleting multiple Macro buttons

I have a workbook with many macro buttons on different sheets. Each month I
run a macro to create a hardcopy version and wonder if there is an easy way
(VBA) to delete/remove all macro buttons from the workbook.

Is this possible?

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

End Sub

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
>
>

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
> >
> >