Adding a toolbar object to the Menu Bar

G

guiguy

When I was using Excel 2000, I used to add the address field to the Men
Bar. This would give me the path (and the filename) of the file I wa
working on. It was the path that I really needed.

I used to accomplish that by just going into customize mode an
dragging the address drop-down from the web toolbar to the main men
bar. That worked.

However, I cannot seem to do that in ExcelXP. I have tried adding it t
Personal.xls which has my macros since that loads every time I ru
Excel. That does not work. I have added it to the menu bar and close
Excel, but that does not work.

I am reluctant to add it to a startup template since I usually star
Excel by clicking on the XLS file I am launching (from Window
Explorer).

Any help on this would be greatly appreciated (in advance!)
 
G

Gord Dibben

quiguy

I have no trouble adding the address bar from the Web Toolbar to another
Toolbar or to the Worksheet Menu Bar with my ExcelXP.

Alternative to the above........

You can customize the Caption on the Title Bar to show the Path and Name.

Code for WorkBook_Open in ThisWorkbook module of Personal.xls

Private Sub workbook_open()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
End Sub


Sub workbook_open()
Application.Caption = "MYAPP"
ActiveWindow.Caption = ""
End Sub

Code for a toggle button......

Sub CaptionToggle()
toggles title bar between document name and full path
If ActiveWindow.Caption = ActiveWorkbook.Name Then
ActiveWindow.Caption = ActiveWorkbook.FullName
Else: ActiveWindow.Caption = ActiveWorkbook.Name
End If
End Sub

Gord Dibben Excel MVP
 
Top