Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Morris, Minnesota, USA
    Posts
    7
    Thanks
    0
    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?

    Jeff

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •