Macro code to clipboard
 

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

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

Macro code to clipboard
 

Majorly awesome, Thank you.

"Mike H" wrote:

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