×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can't change borders of unlocked & unprotected cell

Can't change borders of unlocked & unprotected cell

Can't change borders of unlocked & unprotected cell

(OP)
I think I've entered the twilight zone.  I have a couple of cells on a worksheet that are unlocked and the worksheet is unprotected.  I am unable to edit the borders.  I can, however, edit the fonts, fill color, justification, etc.  The "Format Cells" dialog also will not launch for these cells.  I tried using VBA to modify the borders, to no avail.  Anybody know the super-secret Microsoft option that causes this behavior?

Chris

-------------------------------------------------------------
"Don't be deceived.  We're all temporary employees."

RE: Can't change borders of unlocked & unprotected cell

You might try opening it in Open Office and closing then reopen in Office or save it is OO and reopen in Office.

RE: Can't change borders of unlocked & unprotected cell

Couple of thoughts:
- you may have Window/Freeze Panes on
- did you try copying everything to a new sheet?

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Can't change borders of unlocked & unprotected cell

Did you get this resolved? If not, check to see if these "borders" are not actually a rectangle graphic that someone put there. You should be able to "click" on the border of the rectangle (when sheet is unlocked) if this is the case.

RE: Can't change borders of unlocked & unprotected cell

(OP)
Thanx for the assistance.

I do have Freeze Panes on, but turning it off had no effect.
There are no graphics on the sheet.

I tried a variation of NomLaser's suggestion and saved the workbook in XML format then reopened it.  That fixed the problem.

The bad news is that I have some macros that do some rearranging of cells on the sheet.  Sometimes when I run them the problem reappears.  Seems to be an MS bug.

Chris

-------------------------------------------------------------
"Don't be deceived.  We're all temporary employees."

RE: Can't change borders of unlocked & unprotected cell

do you have conditional formatting turned on?

RE: Can't change borders of unlocked & unprotected cell

Are thos borders actually formatted in the adjoining cells?

RE: Can't change borders of unlocked & unprotected cell

Is Gridlines "checked", in Tools/Options?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources