Format cells with borders

[Jim]

In my sheet there are some cells with borders formatted in and others without
borders. Once a border is set in a cell the Cell Format process seems to no
longer function...right click and select format goes nowhere, top menu format
cells goes nowhere. Cells without borders already set can be formatted.
Does setting a border stop all other formatting?

 

[Gord Dibben]

Jim

Setting a border on a cell should not restrict further formatting of that cell.

Can you type into that cell or otherwise change content?

If you copy another unbordered cell and paste does the border go away?

"Goes nowhere" means if you select a bordered cell then Format>Cells no menu
with options shows up?

Just happens on one sheet or all sheets in the workbook?

You may have some event code that is locking the bordered cells.

Right-click on the sheet tab and "View Code". Anything in that module?


Gord Dibben MS Excel MVP

 

[Jim]

I can enter data in the cells with borders but can not change borders nor
other formating.
Goes Nowhere does mean that no menu with options appears
If I copy un unbordered cell the border goes away but the cell still cannot
be formatted.
There are two sheets in the workbook, both exhibit this condition.
Right-click on sheet tab and selection of worksheet shows this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet was created in QuattroPro, saved as .xls Excel sheet and then opened
on Excel2003. Borders were part of the original QuattroPro worksheet.

End Sub

 

[Gord Dibben]

Those two lines are doing nothing.

I'm now curious.

If you want, email me the workbook and I'll have a look.

Change the AT and DOT appropriately to get my email address.


Gord