software

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

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

=CELL(quot;filenamequot;)
--
Regards,
Davequot;Rick3789quot; wrote:

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

Hi Rick

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

ActiveWindow.Caption = ActiveWorkbook.FullName--
Regards Ron de Bruin
www.rondebruin.nlquot;Rick3789quot; gt; wrote in message ...
gt; Is there a way to show the complete filepath of the current Excel file in a
gt; toolbar line?
gt; =CELL(quot;filenamequot;)

You should add a cell reference to this function.

=CELL(quot;filenamequot;,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
quot;David Billigmeierquot; gt; wrote in message
news
gt; You can display it in a cell by typing the following (verbatim)
gt;
gt; =CELL(quot;filenamequot;)
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Rick3789quot; wrote:
gt;
gt;gt; Is there a way to show the complete filepath of the current
gt;gt; Excel file in a
gt;gt; toolbar line?