Deleting selected macro buttons

[rabbi]

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

[Norman Jones]

Hi Rabbi,

Try something like:

ActiveSheet.Buttons("MyButton1").Delete


---
Regards,
Norman



"rabbi" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>