| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Name
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Name
Try
Application.Caption = "Hi there this is Excel and the file name is " To restore Application.Caption = "" -- Regards Ron de Bruin http://www.rondebruin.nl "Ashman" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Name
"Ashman" wrote in message
... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Name
Many thanks works perfectly.
Jas "Ron de Bruin" wrote: Try Application.Caption = "Hi there this is Excel and the file name is " To restore Application.Caption = "" -- Regards Ron de Bruin http://www.rondebruin.nl "Ashman" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
| Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Linear Mode
