View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Complete path info on Excel window

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andy" wrote in message
...
Thanks Ragdyer, this is very helpful and exactly what I want.

"Ragdyer" wrote in message
...
Couple of ways to get this.

If you've got the screen room to spare, you can simply add the "Web"
toolbar:
<View <Toolbars
And click on "Web".

This gives you, among other tools, the "Address" window, which will
display the full path of all *saved* WBs.

On the other hand, if your strapped for space like me, I added the
"Address" window to my *menu* bar, which always has room to spare.
The size of the window is adjustable, so you can try to display the

entire
path at a glance.
This helps a great deal when you have 3 different servers storing

varying
types of XL files.

To get the individual window, right click in the toolbar and choose
<Customize,
Under the "Commands": tab, scroll down in the left window and click on
"Web",
Then, click on and drag the "Address" box to either your toolbar or your
menu bar.

NOW ... while the "Customize" window is *still* open, click on the
"Address" box to select it, then hover the cursor over the right margin
until it becomes a double sided arrow, then click and drag to adjust the
size as you wish.
--
HTH,

RD


--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-

"Andy" wrote in message
...
Hi,

Is there an add-in that shows the complete path info of the active
workbook at the top of the Excel window. I thought I had seen it before
but I can't find it through google.

Thanks
Andy