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?

Deleting multiple Macro buttons
 

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

Deleting multiple Macro buttons
 

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

Deleting multiple Macro buttons
 

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