Worksheet Protection Problem

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
 
S

S3NTYN3L

bwk5502 said:
I have Excell 2003 (11.5612.5606).
I want to preserve the cells borders, .... what have I overlooked?..

IN the "Protect Sheet" pop-up, are your leaving the "Format Columns",
"Format Rows" checked?

This may be the cause...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top