Custom Macro Toolbar?

[Wuddus]

I have a spreadsheet that has several macros attached to buttons on the
sheet. It is likely that I'll need to put even more macros in, but the
buttons are beginning to clutter the sheet and, besides, are just more
objects that could create problems should other users want to customize the
format.

Is it possible to build a custom toolbar with all the macros as selections
on it? Importantly, it would need to be something that opens automatically
with the workbook and then goes away when the workbook is closed so that
users wouldn't need to access/close it separately. (Chaos would ensure if
they had to deal with this thing separately.) Is there a way to do this with
VBA?

Thanks in advance!

[Ron de Bruin]

See
http://www.rondebruin.nl/menuid.htm#articles

Look at John's page for a great example

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Wuddus" <Wuddus@discussions.microsoft.com> wrote in message news:CED201D2-5E83-4688-BC64-FE115DF427D5@microsoft.com...
>I have a spreadsheet that has several macros attached to buttons on the
> sheet. It is likely that I'll need to put even more macros in, but the
> buttons are beginning to clutter the sheet and, besides, are just more
> objects that could create problems should other users want to customize the
> format.
>
> Is it possible to build a custom toolbar with all the macros as selections
> on it? Importantly, it would need to be something that opens automatically
> with the workbook and then goes away when the workbook is closed so that
> users wouldn't need to access/close it separately. (Chaos would ensure if
> they had to deal with this thing separately.) Is there a way to do this with
> VBA?
>
> Thanks in advance!

[Wuddus]

Wow--this looks pretty comprehensive. Nice page! I'll start investigating
immediately. Thanks!

"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/menuid.htm#articles
>
> Look at John's page for a great example
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Wuddus" <Wuddus@discussions.microsoft.com> wrote in message news:CED201D2-5E83-4688-BC64-FE115DF427D5@microsoft.com...
> >I have a spreadsheet that has several macros attached to buttons on the
> > sheet. It is likely that I'll need to put even more macros in, but the
> > buttons are beginning to clutter the sheet and, besides, are just more
> > objects that could create problems should other users want to customize the
> > format.
> >
> > Is it possible to build a custom toolbar with all the macros as selections
> > on it? Importantly, it would need to be something that opens automatically
> > with the workbook and then goes away when the workbook is closed so that
> > users wouldn't need to access/close it separately. (Chaos would ensure if
> > they had to deal with this thing separately.) Is there a way to do this with
> > VBA?
> >
> > Thanks in advance!
>
>
>

[Wuddus]

Wow--this looks pretty comprehensive. Nice page! I'll start investigating
immediately. Thanks!

"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/menuid.htm#articles
>
> Look at John's page for a great example
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Wuddus" <Wuddus@discussions.microsoft.com> wrote in message news:CED201D2-5E83-4688-BC64-FE115DF427D5@microsoft.com...
> >I have a spreadsheet that has several macros attached to buttons on the
> > sheet. It is likely that I'll need to put even more macros in, but the
> > buttons are beginning to clutter the sheet and, besides, are just more
> > objects that could create problems should other users want to customize the
> > format.
> >
> > Is it possible to build a custom toolbar with all the macros as selections
> > on it? Importantly, it would need to be something that opens automatically
> > with the workbook and then goes away when the workbook is closed so that
> > users wouldn't need to access/close it separately. (Chaos would ensure if
> > they had to deal with this thing separately.) Is there a way to do this with
> > VBA?
> >
> > Thanks in advance!
>
>
>