+ Reply to Thread
Results 1 to 10 of 10

force paste comands to paste>special>values

  1. #1
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    force paste comands to paste>special>values

    Is it possible to execute (force) a paste special values command (by disabling or replacing paste commands with paste special values) when a user attempts to paste (via toolbar button, edit > paste, right click paste & ctrl-V) for the specific destination worksheet (specific active sheet).
    To insure destination cell/s formatting and data validation are not replaced by that of the source.

  2. #2
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Re: force paste comands to paste>special>values

    All experts on the subject are welcome to assist.

    Any ideas people ?
    Thanks

  3. #3
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: force paste comands to paste>special>values

    One way woud be to record macros...
    for paste special value..

    and assing it a key like ctrl+q etc..

    Please Login or Register  to view this content.
    Last edited by Shijesh Kumar; 03-11-2009 at 04:42 PM.

  4. #4
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Re: force paste comands to paste>special>values

    Thnaks but ....
    That does not prevent other users from pasting any data/formats to a cell via various paste techniques (via toolbar button, edit > paste, right click paste & ctrl-V)

    It is these techniques that i want to force a paste aevent to a paste special values event

  5. #5
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: force paste comands to paste>special>values

    After writing the above macros...

    go to tools...
    macros...
    at the bottom u will see OPTION..
    click on that

    U will get a Ctrl + small box..
    in the box enter 'v'

    now when user press ctrl+v it will force paste special value ...

  6. #6
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Re: force paste comands to paste>special>values

    that is a solution to paste via ctrl-V only and does not prevent other methods of paste (via toolbar button, edit > paste, right click paste)
    Any ideas for the others ?

  7. #7
    Registered User
    Join Date
    09-24-2012
    Location
    California
    MS-Off Ver
    Office 2010
    Posts
    33

    Re: force paste comands to paste>special>values

    This is the VB solution that seems to work for me. Hopefully it helps (first time I've offered a solution).

    In each sheet you want to protect:

    Please Login or Register  to view this content.
    In ThisWorkbook:

    Please Login or Register  to view this content.
    In module:

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    01-08-2013
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: force paste comands to paste>special>values

    Hi - I know that this is an old thread - but it very relevant to what i am trying to achieve.

    I have used the code as instructed, but for some reason, when I try copy / paste from one workbook to another all paste and paste special commands are disabled.
    The only time that Paste Special Values becomes enabled (and performs perfectly as I require) is when I
    a) copy cells
    b) close the workbook which I have copied from
    c) ... and then try and paste in my target workbook (the one with the code) ... and then it works

    Any ideas as to why? a remedy?

    Thanks,

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: force paste comands to paste>special>values

    Hi vofstein,

    Yes this thread is old and it doesn't look like they are active right now.

    To increase your queries exposure, please follow the forum rules and post your own thread. You can always place a link back to this thread if necessary.
    HTH
    Regards, Jeff

  10. #10
    Registered User
    Join Date
    01-08-2013
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: force paste comands to paste>special>values

    Quote Originally Posted by jeffreybrown View Post
    Hi vofstein,

    Yes this thread is old and it doesn't look like they are active right now.

    To increase your queries exposure, please follow the forum rules and post your own thread. You can always place a link back to this thread if necessary.
    OK- thanks Jeffrey - I will do so.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1