prevent copying cells

[icestationzbra]

hello,

can copying values from one cell and pasting it onto another cell b
prevented in xl2k or xl2k2?

i have cells in which there are forms checkboxes. i would like th
checkboxes to be usable, however, i would not like the user to copy
checkbox and paste it over other cells. i would like each checkbox t
be manually checked/unchecked.

if i lock a cell with a checkbox in it, and then protect the sheet
upon clicking the checkbox i get an error message about protection.

i tried everything from locked/unlocked to protecting with selectio
for locked/unlocked cells. i also tried 'allow user to edit ranges
etc, to no avail.

i would like to do this without macros.

please help.

thanks.

mac

 

[Harlan Grove]

can copying values from one cell and pasting it onto another cell be
prevented in xl2k or xl2k2?

Yes, but I don't think you need to. If you must, use a SelectionChange, Activate
and Deactivate event handler to set Application.CutCopyMode to False. All are
necessary in order to prevent copying between worksheets.

i have cells in which there are forms checkboxes. i would like the
checkboxes to be usable, however, i would not like the user to copy a
checkbox and paste it over other cells. i would like each checkbox to
be manually checked/unchecked.

Do you mean copy the cells that receive the checkboxes' results? If you mean
copying the checkbox controls, your users can't as long as the controls are
locked but their linked cells which receive their values are unlocked and the
worksheet is protected.

if i lock a cell with a checkbox in it, and then protect the sheet,
upon clicking the checkbox i get an error message about protection.

Not if the linked cells to which the checkboxes send their results are
unprotected. I've been able to make this work on my system.

 

[icestationzbra]

harlan,

thanks for the info. i just figured i could unlock the checkbox and d
the needful.

i need a little help though. there are several checkboxes, and to clic
on each one of them and unlock them would be cumbersome.

i am running a macro to fill columns with checkboxes (provided by dav
peterson).

i am using the following piece:

.Value = xlOff
.LinkedCell = rngCells.Address(external:=false)
.Display3DShading = False
.Caption = ""
.NumberFormat = ";;;"

what is the VBA command that i could use to unlock the checkboxes whe
i create them?

thanks for the help.

mac