Keyboard shortcut for "copy paste special values?"

I copy and paste-special values repeatedly. Is there a keyboard shortcut so
that I don't have to point and click the mouse to "Edit" "Paste Special"
"Values" each time?

I have the button attached to one of my toolbars.

Go to View > Toolbars > Customize and click on the
Command tab. In "Categories" click "Edit" and scroll down
on the right to find "Paste Values". Drag it to one of
your toolbars.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I copy and paste-special values repeatedly. Is there a
keyboard shortcut so
>that I don't have to point and click the mouse
to "Edit" "Paste Special"
>"Values" each time?
>.
>

It might be a little more cumbersome but if you're like me
and don't like to use the mouse you could do Alt>e>s>v>enter.

My only other thought would be to record a macro to "paste
special" and set it to you're own shortcut like ctrl+, or something.

"Star AJ" wrote:

> I copy and paste-special values repeatedly. Is there a keyboard shortcut so
> that I don't have to point and click the mouse to "Edit" "Paste Special"
> "Values" each time?

I know this thread is pretty old, but as it still links via web search I thought I would add this word of caution:

If you use a macro you CANNOT UNDO!

So if you find you have accidentally paste in the wrong place you would have to go back to your last saved version.