Show full pathname in title bar

[GeoLogger]

I have this set for the rest of the computer , but excel persists in showing only the simple filename. I do a great deal of repetitive work involving same-name files and need badly to know which folder I am working in at a glance. Why is excell not on board the title-bar preferences and how do I get the deal done?

 

[Juan Pablo González]

Well, I don't know of any setting(s) to control that, but, this:

Application.Caption = ActiveWorkbook.FullName

would display exactly that... so, you may want to put that macro in a custom button, and click it everytime you want to see the caption...

 

[Jay Petrulis]

Hi,

Not sure if there are better ways, but possibly using a workbook_change event in your personal.xls file that includes the following line

<pre>Application.Caption = ActiveWorkbook.FullName</pre>

would do the job. This may be the only good way to do it in the title bar. I hope others can prove me wrong, but this is all I could think of off the top of my head.

 

[GeoLogger]

Thanks , (I think), I never did a macro. Is this custom button something I would add to the worksheet? ( or each worksheet rather)

 

[royUK]

Hi
The easiest way to learn to write Macros is to use the Create New Macro Button from the Macro Recorder (Tools>Macros>Record New). Do this and stop the Recording immediately, make sure you only do this. Then copy the code from the previous answers and open the Macro Toolbar and click on the macro you have created (Macro 1 by Default). Paste the code into the centre of the Macro

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 19/09/2002 by Roy Cox
'
Your Code Here
'
End Sub




To add a button to your sheet display the Forms Toolbars using the View Toolbars Menu.
DoubleClick on the plain grey button and your cursor will change to a cross. Click on your sheet size and position the Button .A Window will popup to allow you to assign the Macro.

You should now have a Button that activates your Macro
This message was edited by royUK on 2002-09-18 23:00

 

[Geert]

Hi,

please activate the tool "web".

Geert

 

[chef]

Hi.

Try ASAP utilities....

this will allow you to put the file name in the title bar.

http://www.asap-utilities.com/


regards
chef