View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Macro code to clipboard

Steven,

You would need to write your own undo code. Have a look here

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

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Steven" wrote:

I have a macro that Pastes/Special/Values with one click. But it is not
recognized by the undo feature.

Is there a way that I can do this code that the Undo feature can still be
used.

Thank you,

Steven