Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple fill color buttons | Excel Discussion (Misc queries) | |||
Deleting rows in a macro in Excel | Excel Discussion (Misc queries) | |||
CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) | |||
Format Macro Buttons? | Excel Discussion (Misc queries) | |||
Spreadsheet print including macro buttons? | Excel Discussion (Misc queries) |