myMenul.Caption = "P&L Report"
 

Hello NG,

My code created additional menu to worksheet menu bar. My problem is I
cannot set my caption to hold the ampersand (&) because it is regarded as
the shortcut for the menu thus underlining the L. I am hoping that a
character can be put prior to the ampersand just like using slash (\) in
format function.

Please help.

TIA

Jon-jon

myMenul.Caption = "P&L Report"
 

Hi Jon-jon,

Use "&" twice as under.

myMenul.Caption = "P&&L Report"


Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

myMenul.Caption = "P&L Report"
 

Shah,

I almost lost all my hair for this. Thanks a lot!

Jon-jon

"Shailesh Shah" wrote in message
...
Hi Jon-jon,

Use "&" twice as under.

myMenul.Caption = "P&&L Report"


Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!