Menu Name

[Guest]

Is there anyway of using a macro to change the Microsoft Excel Menu, ie it
dispays Microsoft Excel plus the file name. I am wanting to add something in
before the file name.

Is this possible?

Jas

 

[Ron de Bruin]

Try

Application.Caption = "Hi there this is Excel and the file name is "

To restore

Application.Caption = ""

 

[Rob Bovey]

Is there anyway of using a macro to change the Microsoft Excel Menu, ie it
dispays Microsoft Excel plus the file name. I am wanting to add something
in
before the file name.
Is this possible?

Hi Jas,

I think you are referring to the caption - the text that appears in the
blue bar at the very top of the Excel window? If so, there are two parts to
this caption:

Application.Caption = "Something Else"

changes "Microsoft Excel" to "Something Else"

ActiveWindow.Caption = "Something Else"

changes the file name to "Something Else". You can use these two separately
or together. To restore the captions to their default values, use the
following:

Application.Caption = Empty
ActiveWindow.Caption = False

I know it doesn't make much sense, but that's how it works.

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

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Guest]

Many thanks works perfectly.

Jas

Try

Application.Caption = "Hi there this is Excel and the file name is "

To restore

Application.Caption = ""