Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting selected macro buttons
Hello everyone Is there an easy way of deleting the macro click buttons by the name you have assigned them and not by it's automatic button number? It is getting difficult to keep track of the number of buttons and when the sheet is copied the button numbering changes on the copied sheet. is there a way of using the button command eg. ActiveSheet.Buttons.??? Any help would be appreciated Thanks Rabbi -- rabbi ------------------------------------------------------------------------ rabbi's Profile: http://www.excelforum.com/member.php...o&userid=20178 View this thread: http://www.excelforum.com/showthread...hreadid=396728 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting selected macro buttons
Hi Rabbi,
Try something like: ActiveSheet.Buttons("MyButton1").Delete --- Regards, Norman "rabbi" wrote in message ... Hello everyone Is there an easy way of deleting the macro click buttons by the name you have assigned them and not by it's automatic button number? It is getting difficult to keep track of the number of buttons and when the sheet is copied the button numbering changes on the copied sheet. is there a way of using the button command eg. ActiveSheet.Buttons.??? Any help would be appreciated Thanks Rabbi -- rabbi ------------------------------------------------------------------------ rabbi's Profile: http://www.excelforum.com/member.php...o&userid=20178 View this thread: http://www.excelforum.com/showthread...hreadid=396728 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms Option Buttons(Can be right mouse selected when sheet is loc | Excel Discussion (Misc queries) | |||
deleting selected rows | Excel Discussion (Misc queries) | |||
Deleting multiple Macro buttons | Excel Discussion (Misc queries) | |||
Deleting option buttons | Excel Discussion (Misc queries) | |||
Deleting all buttons in a collection | Excel Programming |