How do I show the current Excel filepath in the toolbar line?
 

Is there a way to show the complete filepath of the current Excel file in a
toolbar line?

How do I show the current Excel filepath in the toolbar line?
 

You can display it in a cell by typing the following (verbatim)

=CELL("filename")
--
Regards,
Dave


"Rick3789" wrote:

Is there a way to show the complete filepath of the current Excel file in a
toolbar line?

How do I show the current Excel filepath in the toolbar line?
 

Hi Rick

Only with code you can do it as far as I know

ActiveWindow.Caption = ActiveWorkbook.FullName


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rick3789" wrote in message ...
Is there a way to show the complete filepath of the current Excel file in a
toolbar line?

How do I show the current Excel filepath in the toolbar line?
 

=CELL("filename")

You should add a cell reference to this function.

=CELL("filename",A1)

Otherwise, the result will be the active workbook when a
calculation is made, which may not be the same workbook that
contains the formula. Including a cell reference -- any cell will
do -- will prevent this error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"David Billigmeier" wrote in message
...
You can display it in a cell by typing the following (verbatim)

=CELL("filename")
--
Regards,
Dave


"Rick3789" wrote:

Is there a way to show the complete filepath of the current
Excel file in a
toolbar line?