Hi all,

I have designed a custom toolbar that I have attached to the
developing workbook, and then saved as an add in. I intend to
disseminate this to colleagues as an addin, however I also want them
to have the option of having the toolbar as a dropdown menu
(incorporated on the main "worksheet menu bar").

Is it possible to attach additional menus, like you can with toolbars?
Or permanently create a new menu in code?

If not, I guess it is necessary for the addin to automatically
generate the menu when it loads, but i cant work out how to do this.
Perhaps create a new menu, and then copy and paste each toolbar button
into it (again, not sure how though)? There are 10 or so buttons,
presumably you can iterate, but they all have custom names, button
images, and assigned macros.

If you are able to illustrate with code, much appreciated!

Thanks

Stu

Here is an article which talks about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm


http://support.microsoft.com/default...b;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
--
Regards,
Tom Ogilvy


"Stu" wrote in message
m...
Hi all,

I have designed a custom toolbar that I have attached to the
developing workbook, and then saved as an add in. I intend to
disseminate this to colleagues as an addin, however I also want them
to have the option of having the toolbar as a dropdown menu
(incorporated on the main "worksheet menu bar").

Is it possible to attach additional menus, like you can with toolbars?
Or permanently create a new menu in code?

If not, I guess it is necessary for the addin to automatically
generate the menu when it loads, but i cant work out how to do this.
Perhaps create a new menu, and then copy and paste each toolbar button
into it (again, not sure how though)? There are 10 or so buttons,
presumably you can iterate, but they all have custom names, button
images, and assigned macros.

If you are able to illustrate with code, much appreciated!

Thanks

Stu

Stu,

Take a look at the previous thread 'Excel Menus That Fold Out' in this
thread. It is on the same topic.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
m...
Hi all,

I have designed a custom toolbar that I have attached to the
developing workbook, and then saved as an add in. I intend to
disseminate this to colleagues as an addin, however I also want them
to have the option of having the toolbar as a dropdown menu
(incorporated on the main "worksheet menu bar").

Is it possible to attach additional menus, like you can with toolbars?
Or permanently create a new menu in code?

If not, I guess it is necessary for the addin to automatically
generate the menu when it loads, but i cant work out how to do this.
Perhaps create a new menu, and then copy and paste each toolbar button
into it (again, not sure how though)? There are 10 or so buttons,
presumably you can iterate, but they all have custom names, button
images, and assigned macros.

If you are able to illustrate with code, much appreciated!

Thanks

Stu

I have commandbar examples on my website

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Stu" wrote in message
m...
Hi all,

I have designed a custom toolbar that I have attached to the
developing workbook, and then saved as an add in. I intend to
disseminate this to colleagues as an addin, however I also want them
to have the option of having the toolbar as a dropdown menu
(incorporated on the main "worksheet menu bar").

Is it possible to attach additional menus, like you can with toolbars?
Or permanently create a new menu in code?

If not, I guess it is necessary for the addin to automatically
generate the menu when it loads, but i cant work out how to do this.
Perhaps create a new menu, and then copy and paste each toolbar button
into it (again, not sure how though)? There are 10 or so buttons,
presumably you can iterate, but they all have custom names, button
images, and assigned macros.

If you are able to illustrate with code, much appreciated!

Thanks

Stu