Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Path Name in Title Bar (Excel 2000)

    Hi Everyone,
    Since I followed the instructions to create a macro that puts the full path name in the title bar [see <post#=168387>post 168387</post#>], saving any Excel file causes the file to go to the first tab in the workbook and then save the file. Is there a way to have the file saved without reverting to the first tab?

    TIA
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Path Name in Title Bar (Excel 2000)

    This post 214928 may help

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Path Name in Title Bar (Excel 2000)

    Kieran-would you mind walking through the process-I couldn't follow it!
    Thanks,
    Jeff

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Path Name in Title Bar (Excel 2000)

    Jeff,

    Take a look at Phil Rabichow's tip in <post#=107257>post 107257</post#>. It has step-by-step instructions. That post is for Word, but it works in Excel and PowerPoint too.

    (I get a sense of d

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Path Name in Title Bar (Excel 2000)

    Yep-as Yogi said"...deja vu all over again..."; sorry, misplaced the previous post!
    Thanks for your patience!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •