Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ant
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ant
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Scott
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple fill color buttons susielotus Excel Discussion (Misc queries) 1 February 5th 06 04:04 PM
Deleting rows in a macro in Excel THEFALLGUY Excel Discussion (Misc queries) 4 December 23rd 05 02:59 PM
CREATE MACRO TO COPY MULTIPLE WORKSHEETS Bewilderd jim Excel Discussion (Misc queries) 5 March 3rd 05 11:00 PM
Format Macro Buttons? Ken Excel Discussion (Misc queries) 5 March 2nd 05 09:40 PM
Spreadsheet print including macro buttons? gunga Excel Discussion (Misc queries) 4 February 10th 05 07:30 PM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"