ALLOWING ONLY PASTE SPECIAL (URGENT)

[Guest]

URGENT HELP REQUIRED!

HOW CAN OU RESTRICT A USER TO ENTER A COPIED DATA BY PASTING ONLY VALUES.

IN OTHER WORDS I DON'T WANT THE FORMAT OF THE CELLS TO BE CHANGED DUE TO
NORMAL PASTING BY CTRL+V OR HITTING ENTER.

 

[Ssssssh]

URGENT HELP REQUIRED!

HOW CAN OU RESTRICT A USER TO ENTER A COPIED DATA BY PASTING ONLY VALUES.

IN OTHER WORDS I DON'T WANT THE FORMAT OF THE CELLS TO BE CHANGED DUE TO
NORMAL PASTING BY CTRL+V OR HITTING ENTER.

8888888 d8b 888 888
888 Y8P 888 888
888 888 888
888 .d8888b 888 888888 888888 .d88b.
888 88K 888 888 888 d88""88b
888 "Y8888b. 888 888 888 888 888
888 X88 888 Y88b. Y88b. Y88..88P
8888888 88888P' 888 "Y888 "Y888 "Y88P"



888
888
888
88888b. 888d888 .d88b. 888 888 .d88b. 88888b. 888888
888 "88b 888P" d8P Y8b 888 888 d8P Y8b 888 "88b 888
888 888 888 88888888 Y88 88P 88888888 888 888 888
888 d88P 888 Y8b. Y8bd8P Y8b. 888 888 Y88b.
88888P" 888 "Y8888 Y88P "Y8888 888 888 "Y888
888
888
888
888
888
888
88888b. .d88b. .d88b. 88888b. 888 .d88b.
888 "88b d8P Y8b d88""88b 888 "88b 888 d8P Y8b
888 888 88888888 888 888 888 888 888 88888888
888 d88P Y8b. Y88..88P 888 d88P 888 Y8b.
88888P" "Y8888 "Y88P" 88888P" 888 "Y8888
888 888
888 888
888 888
d8b 888 888
Y8P 888 888
888 888
8888b. .d8888b .d8888b 888 .d88888 .d88b. 88888b. 888888
"88b d88P" d88P" 888 d88" 888 d8P Y8b 888 "88b 888
..d888888 888 888 888 888 888 88888888 888 888 888
888 888 Y88b. Y88b. 888 Y88b 888 Y8b. 888 888 Y88b.
"Y888888 "Y8888P "Y8888P 888 "Y88888 "Y8888 888 888 "Y888



888 888
888 888
888 888
8888b. 888 888 888 888
"88b 888 888 888 888
..d888888 888 888 888 888
888 888 888 888 Y88b 888
"Y888888 888 888 "Y88888
888
Y8b d88P
"Y88P"
888 d8b d8b
888 Y8P Y8P
888
888888 888 888 88888b. 888 88888b. .d88b. 888 88888b.
888 888 888 888 "88b 888 888 "88b d88P"88b 888 888 "88b
888 888 888 888 888 888 888 888 888 888 888 888 888
Y88b. Y88b 888 888 d88P 888 888 888 Y88b 888 888 888 888
"Y888 "Y88888 88888P" 888 888 888 "Y88888 888 888 888
888 888 888
Y8b d88P 888 Y8b d88P
"Y88P" 888 "Y88P"
888 888
888 888
888 888
8888b. 888 888
"88b 888 888
..d888888 888 888
888 888 888 888
"Y888888 888 888



d8b 888 888
Y8P 888 888
888 888
.d8888b 8888b. 88888b. 888 888888 8888b. 888 .d8888b
d88P" "88b 888 "88b 888 888 "88b 888 88K
888 .d888888 888 888 888 888 .d888888 888 "Y8888b.
Y88b. 888 888 888 d88P 888 Y88b. 888 888 888 X88
"Y8888P "Y888888 88888P" 888 "Y888 "Y888888 888 88888P'
888
888
888
888
888
888
88888b. 888 888
888 "88b 888 888
888 888 888 888
888 d88P Y88b 888
88888P" "Y88888
888
Y8b d88P
"Y88P"
888 .d8888b.
888 d88P Y88b
888 .d88P
.d8888b 88888b. 8888b. 88888b. .d8888b .d88b. .d88P"
d88P" 888 "88b "88b 888 "88b d88P" d8P Y8b 888"
888 888 888 .d888888 888 888 888 88888888 888
Y88b. 888 888 888 888 888 888 Y88b. Y8b.
"Y8888P 888 888 "Y888888 888 888 "Y8888P "Y8888 888

 

[Guest]

Hello Faraz

You cann use paste special values only

 

[Don Guillett]

Please repost with a meaningful subject line without the wolf cry for
urgency. Do NOT shout by typing in all caps.

 

[Gord Dibben]

Faraz

Please do not post in all caps. Hard on the ears.

Found this event code posted by someone you could use.

Private Sub Worksheet_Change(ByVal Target As Range)
'retain formatting when a cell is copied over
Dim myValue
With Application
.EnableEvents = False
myValue = Target.Value
.Undo
Target = myValue
.EnableEvents = True
End With
Application.CutCopyMode = False
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code".

Copy/paste the above into that module.


Gord Dibben MS Excel MVP

URGENT HELP REQUIRED!

HOW CAN OU RESTRICT A USER TO ENTER A COPIED DATA BY PASTING ONLY VALUES.

IN OTHER WORDS I DON'T WANT THE FORMAT OF THE CELLS TO BE CHANGED DUE TO
NORMAL PASTING BY CTRL+V OR HITTING ENTER.

Gord Dibben MS Excel MVP

 

[Guest]

sorry sir(s)
but sure was in a panic due to a new project with tight deadline.
thanx 4 the xclent vba assistance.
regards
faraz