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

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