Hi all,

I am creating a custom Menu which will get deleted when
activating another workbook and recreated when
opening/activating my workbook.

Is it possible to change the colour of Menus / subMenus
(back color / fore color) of this custom menu only? ie
when i activate another workbook the default color should
come back..

any Help?

TIA
Soniya

Hi Soniya,

Unfortunately, the backcolor and forecolor of menus and toolbars if
fixed. Or from VBA, at least, these colors are determined by the user's
system-wide settings. Just about the only appearance-related thing you can
customize is whether or not to show an icon.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Soniy" wrote in message
...
Hi all,

I am creating a custom Menu which will get deleted when
activating another workbook and recreated when
opening/activating my workbook.

Is it possible to change the colour of Menus / subMenus
(back color / fore color) of this custom menu only? ie
when i activate another workbook the default color should
come back..

any Help?

TIA
Soniya