Excel Macros

[Guest]

I created a button on my toolbar and assigned a macro to it to paste values.
It works, but if I need to undo the paste values after using it, I can't
because the undo button is grayed out. Any thoughts?

 

[Guest]

Rey M:

John Walkenbach's site has a good discussion:


http://www.j-walk.com/ss/excel/tips/tip23.htm

 

[Norman Jones]

Hi M,

Try using the built in functionality:

View | Toolbars | Customize
Select Edit in the Categories box
Drag the 'Paste Values' icon from the Commands box to a toolbar.

 

[Guest]

Thank you for the help.

Rey M:

John Walkenbach's site has a good discussion:


http://www.j-walk.com/ss/excel/tips/tip23.htm