| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macros
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Macros
Rey M:
John Walkenbach's site has a good discussion: http://www.j-walk.com/ss/excel/tips/tip23.htm -- http://www.vba.com.tw/plog/ "Rey M" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Macros
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. --- Regards, Norman "Rey M" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Macros
Thank you for the help.
"chijanzen" wrote: Rey M: John Walkenbach's site has a good discussion: http://www.j-walk.com/ss/excel/tips/tip23.htm -- http://www.vba.com.tw/plog/ "Rey M" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| Making excel macros run Word macros | Excel Programming | |||
Linear Mode
