Color of Menus and subMenus

[Soniy]

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

 

[Rob Bovey]

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 *