Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Excel 97 - Saving Toolbar/Icon Settings

    Excel 97 - Saving Toolbar/Icon Settings

    What files and folders are the Toolbar/Icon settings stored in? I would like to make a copy and store them safely in another location or at least as a back-up.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    I use this batch file which copies key Excel97 and Word97 settings to my network drive ... I hope! The Excel toolbars and icons file is on the first line here (substitute "MYNAME" with "<yourusername>"). Your "custom.dic" may be in a different location. Paths: "progra~1" is "program files", "micros~1" is "microsoft office", "templa~1" is "templates".

    @XCOPY32 /Y C:WINDOWSMYNAME8.XLB U:*.* >nul
    @XCOPY32 /Y C:PROGRA~1MICROS~1 OFFICEXLSTARTPERSONAL.XLS U:*.* >nul
    @XCOPY32 /Y C:PROGRA~1MICROS~1TEMPLA~1NORMAL.DOT U:*.* >nul
    @XCOPY32 /Y C:PROGRA~1MICROS~1OFFICECUSTOM.DIC U:*.* >nul
    @EXIT
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    John,
    Thanks.
    1 - I found username8.xlb under C:WINNT.
    2 - For the record, I found Custom.dic under C:Program FilesMicrosoft OfficeOffice and Normal.dot under C:Program FilesMicrosoft OfficeTemplates, just as you said.
    3 - I did not realize there was an updated xcopy around. What's the "Y" switch, overite-Yes?
    4 - I see you use Personal.xls. What's the implementation, is the file always open or can it be hidden? I don't seem to find much info on Personal.xls

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    I should have stated that my answers assume W9x. Re your questions:

    3. Xcopy32 is nothin' but the 32 bit xcopy distributed in W9x. "/Y" indeed tells it to overwrite existing files.

    4. I didn't think you could run Excel withOUT a personal.xls; it's the usual place to keep all your macros available for all Excel workbooks; much like normal.dot is for Word. By default it is opened if it exists, and hidden. I have a bunch of little convenience macros in it, nothing like the giant-killers you'll see from the VBA gurus posting here.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    I have created a file which I call menu.xls and saved it in C:Program FilesMicrosoft OfficeOfficeXLStart. This is the file that opens each time I restart Excel. Since I use it as a menu, I like to have the file open, switch to it and then select a button to execute a macro. But when I save personal.xls and save it there also, it opens in full view. Is there a switch or setting I am missing to allow me to hide personal.xls?

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    John,
    While we're on the subject, is there (I'm sure there is, but I don't know how) a way to put your batch file into a macro in my Menu.xls? That way I could "backup" my *.xlb right from Excel.

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    This may interest you

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=23196&page=8&view =expanded&sb=5>disappearing buttons</A>

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    My reply to Mouse right click menu from a cell (01/01/07) may be helpful.

    Question. How do you paste links to another reply?

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    Just to the right of the subject of a reply is a button labeled "Show 1-Click TagPanel". If you click on that button you will get a window with the message formatting controls in it. If you hover your mouse pointer over the buttons, a pop up will give the name of the buttons. The two at the right end of the top row are the ones for inserting a link. The first one is used to insert a link that looks like a URL, and the second one inserts a link that looks like a hilighted word or description.

    Copy the URL of the link you want to insert. Put your cursor at the point in your message where you want the link and click on one of the link buttons. That will insert something that looks like this (url=link)description(/url) into your message with the parenthesis replaced by square brackets. Select the word "link" and paste your URL over it. Select the word "description and type your description over it.
    Legare Coleman

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    Thanks Legare, I had looked there but hadn't worked out how to use it.

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    Any valid Excel file in "..xlstart" gets loaded upon Excel startup. You hide "personal.xls" from the Window menu, when you exit Excel you'll be asked if you want to save the changes; say yes and "personal.xls" will be hidden until you want to unhide it.
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel 97 - Saving Toolbar/Icon Settings

    You would have to rewrite it as VBA code, or call the batch file through a VBA shell command. Might be best to write it as an Application.WorkbookBeforeClose event in your personal.xls or menu.xls. But I'm out of my depth now; Hans, Legare or another VBA guru can help you there.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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