Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    format text box (etc (972b, 2000)

    It's easy to adjust the default format for text boxes, autoshapes, callouts etc by setting one up the way you want (eg transparent, thin red line) and issuing the 'make this the default' command.
    However, this only 'sticks' for subsequent objects within the same workbook.
    How can I make it the global default for all objects for all new workbooks?
    (In Word, it's done by rejigging normal.dot, but if there's an excel equivalent like 'normal.xlt' I've yet to find it.)
    Thanks!

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

    Re: format text box (etc (972b, 2000)

    There are several Excel files that play the part of Normal.dot:
    <UL><LI>Personal.xls contains your personal macros.
    <LI>Book.xlt contains standard workbook-level settings. If you have created a template Book.xlt in your XLStart folder, it will be used as model when you create a blank new workbook.
    <LI>Sheet.xlt contains standard worksheet-level settings. If you have created a template Sheet.xlt in your XLStart folder, it will be used as model when you insert a new worksheet into a workbook.
    <LI>A file with extension .xlb contains your toolbar customizations and custom lists.[/list]I would try to create a workbook and set the defaults for text boxes etc. as you like. Don't leave any of those in the finished workbook, though. Save it as an Excel template Book.xlt in your XLStart folder.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: format text box (etc (972b, 2000)

    Thanks very much, Hans, works a treat.
    [Loads of scope for April Fool wheezes here - create someone a Book.xlt they don't know about, containing a blood-red rectangle about 5 screens big. When they crank up excel, they'll wonder what's broken? You didn't see it here first!]

Posting Permissions

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