add text into right-side of menu bar
 

Hi,

The left side of menu bar is "File....."
How can I add text into right side of menu bar?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=544189

add text into right-side of menu bar
 

Do you mean add your own sub-menu, or just some text at the end?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"gabch" wrote in
message ...

Hi,

The left side of menu bar is "File....."
How can I add text into right side of menu bar?


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=544189

add text into right-side of menu bar
 

Try with this:

Dim custMenu As CommandBarControl

Set custMenu =
Application.CommandBars(1).Controls.Add(Type:=msoC ontrolPopup)

custMenu.Caption = "&New Menu Files"

Please Note that index 1 normally is the "Worksheet Menu Bar"

Bye Bye

Cecco

"gabch" wrote:


Hi,

The left side of menu bar is "File....."
How can I add text into right side of menu bar?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=544189

add text into right-side of menu bar
 

Add text need the min button at menu bar.


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=544189