Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard? tskogstrom Excel Programming 2 March 6th 07 12:50 PM
Pasting in code and clipboard message KarenH Excel Programming 0 May 2nd 06 07:28 PM
Code to handle clipboard message D. Pirate Roberts Excel Programming 1 October 3rd 05 11:31 PM
How to empty the clipboard using vba code Robin Ketting Excel Programming 1 February 17th 04 11:35 AM


All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"