Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    change 'line' color in AutoShapes Cmd (excel 2003)

    In MS 2003 Excel - Tools - Customize - Commands - AutoShapes ;
    how to change permanently the color of "line".
    Thank you

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

    Re: change 'line' color in AutoShapes Cmd (excel 2003)

    I don't know if that is possible. You can set the default for the current workbook:

    Close the Customize dialog if it's open.
    Activate the Drawing toolbar.
    Create a line with the color, width and style that you'd want to be the default.
    Right-click the line and select "Set AutoShape Default" from the popup menu.

    The current workbook will use the settings that you specified, even when you save it, close it and reopen it. But the settings won't apply to other workbooks - each workbook can have its own AutoShape defaults.

  3. #3
    New Lounger
    Join Date
    Aug 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: change 'line' color in AutoShapes Cmd (excel 2

    Thank you for the fast reply.

    Regret to say, I am unable to find the cmd to :

    "Create a line with the color, width and style that you'd want to be the default."

    Best Regards

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: change 'line' color in AutoShapes Cmd (excel 2

    All Hans was suggesting was to format the shape as you would normally (dlb-click to get "format shape" and in the various tabs change them as desired.

    Steve

  5. #5
    New Lounger
    Join Date
    Aug 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: change 'line' color in AutoShapes Cmd (excel 2

    Thank you Hans and Steve :

    I manged to follow suggestion of Hans :
    Open XL file - drew a line in Drawings - Rtclick the line - Format AutoShapes, change color to red - Rtclick the line, Set AutoShapes Defaults - save file.

    Best Regards

Posting Permissions

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