Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    border tools not available (Excel 2002)

    I've done something and now I can't use my border tools to change line width, color, etc. Can someone help me get this feature turned back on? Thanks!

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

    Re: border tools not available (Excel 2002)

    - Do you happen to be editing a formula?
    - Do you happen to have protected the worksheet (Tools | Protection | Protect Sheet...)

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

    Re: border tools not available (Excel 2002)

    Is the worksheet possibly protected?

    Is this just in one workbook, on just one worksheet, or is it for all worksheets in all workbooks? What border tools are you talking about, the one on the tool bar, or the one on the border tab of the Format Cells dialog box? Is it completely missing or is it there but disabled (grayed out)? Are there any VAB event routines in the workbook?
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: border tools not available (Excel 2002)

    Thanks for the reply!
    This is happening on all my workbooks and worksheets, new and old.
    I have it on the toolbar, but its disabled.

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

    Re: border tools not available (Excel 2002)

    See if the steps in Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> help.

Posting Permissions

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