ExcelBanter - Cell (Border Only) Protection

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Cell (Border Only) Protection (https://www.excelbanter.com/new-users-excel/98528-cell-border-only-protection.html)

Newbee

Cell (Border Only) Protection

How do I protect the border (format) of a cell? Is it possible? I'm
currently using Excel 2002.

Thanks.

swatsp0p

Cell (Border Only) Protection

Make sure the desired cell is locked (FormatCellsProtection) then
protect the worksheet (ToolsProtectionProtect Sheet...) you may add
password security if desired (not necessary).

Good Luck

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=560128

All times are GMT +1. The time now is 08:36 AM.