add text into right-side of menu bar

[gabch]

Hi,

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

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Cecco (ITA)]

Try with this:

Dim custMenu As CommandBarControl

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

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
>
>

[gabch]

Add text need the min button at menu bar.