B
bwk5502
I have Excell 2003 (11.5612.5606).
My worksheet is protected (tools+protection+protect worksheet), and fo
the most part, the protection seems to be doing its thing okay. When
go to protect the worksheet, the only thing I have checked to allow th
user to do is "select unlocked cells"; the "format cells" is NO
checked. I have used the format+cells+protection to lock only the cell
I want protected.
The problem is when the user uses "CTRL C" & "CTRL V" to copy and past
data from one cell to another, it also copies the cell's format (???)
As a result, the border lines (thin and thick) get messed up when th
data is pasted.
I want to preserve the cells borders, .... what have I overlooked?
Thanks,
Bil in Kansa
My worksheet is protected (tools+protection+protect worksheet), and fo
the most part, the protection seems to be doing its thing okay. When
go to protect the worksheet, the only thing I have checked to allow th
user to do is "select unlocked cells"; the "format cells" is NO
checked. I have used the format+cells+protection to lock only the cell
I want protected.
The problem is when the user uses "CTRL C" & "CTRL V" to copy and past
data from one cell to another, it also copies the cell's format (???)
As a result, the border lines (thin and thick) get messed up when th
data is pasted.
I want to preserve the cells borders, .... what have I overlooked?
Thanks,
Bil in Kansa