Solved Paste values only

[Guus2005]

Dear reader,

I have a protected workbook and sheets but i am unable to prevent users from copying and pasting values in my sheets.
It is a popular way to use the spreadsheet and fill it with data. I can understand that.

But copying a value from one spreadsheet to another using ^c, ^v always copies the formatting also.
Is there a way to paste values only, without the obvious rightclick and select paste values, because the mouse rightclick was succesfully disabled.

Thanks for your time.

 

[Ranman256]

If the sheet is protected,then one cannot type,nor paste anything into the sheet.

 

[arnelgp]

Alt-e, s, v (click OK)

 

[Guus2005]

Thanks Ranman256 and arnelgp,

In Access we can catch keystrokes using the AutoKeys macro.
What is the equivalent in Excel?

 

[Isaac]

There is no way to programmatically capture the event of pasting, specifically. But you may be able to code worksheet change event and then Clear formatting from the Target. That may be too sweeping a result, though, for your needs.

 

[arnelgp]

see this thread:

Is there any event that fires when keys are pressed when editing a cell?

Is it in any way possible to capture events as you press a key in (make an edit to) a specific cell in a worksheet? The closest one is know is the Change Event but that can only be activated as s...

stackoverflow.com

 

[Guus2005]

If it was for personal use only, i would have considered the last solution by Arnelgp. But it is an application for a few hundred users, and i don't know if the solution is worse than the problem.
As you can understand, it is a big risk to introduce this solution when only 1 user has this problem.
So i will leave it the way it is.

Thanks for your time!

 

[Isaac]