Paste Value

P

pepps

I have a spreadsheet that is used to collect information, ie, a for
with data entry fields. I lock all the fields that should not change
and protect the worksheet. I have data validation for numeric fields a
"whole number, greater than or equal to 0". However, if the user paste
a green background with .8 thick lines, it will paste numeric only data
but mess up the color and border formatting. The only thing the use
can do is "Select locked cells" or "Select unlocked cells". The Selec
locked cells is checked because I use the "Comments" as mouse-ove
pop-up instructions.

This works great except that I can't stop people from pasting into th
fields that are not locked. I would be fine if they pasted/value only
Does anyone know a way in VB to ensure that ALL pastes to a workshee
automatically and only use Paste/Value feature
 
I

isabelle

hi pepps,

the only solution i see is to apply the format known to cells that undergo a change.
this is possible via the event:
Private Sub Worksheet_Change (ByVal Target As Range)

--
isabelle



Le 2012-06-08 18:02, pepps a écrit :
 

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