Results 1 to 2 of 2
Thread: Paste macros (2000)
2001-10-30, 14:03 #1
- Join Date
- Oct 2003
- Morris, Minnesota, USA
- Thanked 0 Times in 0 Posts
Paste macros (2000)
I programmed the macros for pasting in Excel as suggested in the 2 recent WOW issues, but I promptly deleted them when I belatedly remembered that "Undo" (CTRL+Z) doesn't work after a macro has been executed.
Does anybody have a way around that annoyance? I'm so used to using the "Undo" command that I'd rather deal with my old (and very functional, I might add) method of using a keyboard shortcut to paste formatting and values. My old method involved customizing the toolbar with the "Paste Formatting" and "Paste Values" icons from the Edit category, and then viewing "Text Only" and changing the name to "P&aste Formatting" and "Pa&ste Values", respectively, so that I can use ALT+A and ALT+S as keyboard shortcuts. CTRL+V still pastes everything.
Any ideas on how to undo macros?
2001-10-30, 14:12 #2
- Join Date
- Mar 2001
- Springfield, Ohio, USA
- Thanked 2 Times in 2 Posts
Re: Paste macros (2000)
See John Walkenbach's page on undoing macros:
<A target="_blank" HREF=http://www.j-walk.com/ss/excel/tips/tip23.htm>http://www.j-walk.com/ss/excel/tips/tip23.htm</A>.
Lots of other good stuff there also. HTH --Sam<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>