another option would be to make a macro something like

Sub pastval()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub
in <tools<marcos<macro select options and set your own Control combo
unfortunately it has to include shift so that you can't just replace Control V
I used Control shift V in my trial

"Tsjah" wrote:

Hmm, I usually use ctrl-v to paste.. But still, I want it to happen
automaticly, something like "=permanent(blah!C33) but unfortunately there is
no such function (as far as I know)

Thanks anyway!
"bj" wrote in message
...
I would customize your tool bar, Remove the standard Paste button and add
the paste values button. You could still paste from the drop down menu,

If you only want to do this sometimes you could put together a quick menu
to
trade the two buttons as needed.
"Tsjah" wrote:

Hello,

Is it possible to copy values from one cell in to another (automaticly)
and
then just storing the copied value, not the formula? This is for changing
numbers I would like to store dayly. Up to now I just do a copy, paste
special, values, but obviously I tend to forget..

Thanks a lot in advance,

Mike