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
RE: Can't change borders of unlocked & unprotected cell
- 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
RE: Can't change borders of unlocked & unprotected cell
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
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Can't change borders of unlocked & unprotected cell
RE: Can't change borders of unlocked & unprotected cell
RE: Can't change borders of unlocked & unprotected cell