Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: how can I re-enable copy/paste

  1. #1
    Board Regular
    Join Date
    Mar 2008
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how can I re-enable copy/paste

    I was testing the following methods (suggested in another thread) to disable copy/paste on a particular worksheet -- now copy and paste is disabled entirely from Excel and, apparently, from each and every excel workbook I've got. HELP!!!!!

    http://www.xcelfiles.com/VBA_Quick13.html

    http://www.mrexcel.com/archive2/75500/87639.htm



    Taxstar

  2. #2
    Board Regular
    Join Date
    Mar 2008
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    Silly me - panicked way too soon. All I had to do was run the 'enable' macro and I'm back in business.


    Taxstar

  3. #3
    New Member
    Join Date
    Dec 2014
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    What is the enable macro?

    There is a link that no longer works.

  4. #4
    Board Regular
    Join Date
    Mar 2008
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    Sorry, Chris - that was nearly 7 years ago and I don't recall what the fix was.

  5. #5
    New Member
    Join Date
    Dec 2014
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    No worries Taxstar, I started a new thread and put the data into it in the hopoe that a VBA wizard can help. Thanks for the speedy reply

  6. #6
    Board Regular
    Join Date
    Dec 2014
    Location
    little ole England
    Posts
    1,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: how can I re-enable copy/paste

    could try this

    Code:
    
    Application.CutCopyMode=True 
    ◄ŦяμвŁ►
    By Name and By Nature

    i know nothing but i know everything about it
    please take everything i type with a pinch of salt i am only learning this stuff as i go along. Please make a post helping someone else
    Want to post a small screen shot? Try MrExcel HTML Maker
    How To Install MrExcel HTML Maker: https://www.youtube.com/watch?v=Jycv...ature=youtu.be

  7. #7
    New Member
    Join Date
    Dec 2014
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    Quote Originally Posted by AkaTrouble View Post
    could try this

    Code:
    
    Application.CutCopyMode=True 
    I created a macro with

    Sub Enable_CopyPaste()
    Application.CutCopyMode = True
    End Sub

    however it did nothing. Paste and Paste Special are still greyed out.

    I have started a new thread regarding this issue http://www.mrexcel.com/forum/excel-q...opy-paste.html
    Last edited by ChrisCoord; Dec 29th, 2014 at 05:14 PM. Reason: multiple threading

  8. #8
    Board Regular
    Join Date
    Dec 2014
    Location
    little ole England
    Posts
    1,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: how can I re-enable copy/paste

    might need to look at original disable code

    it may say

    application.cutcopypaste = false

    this would need to be reversed with = true

    can you post disable code you used
    ◄ŦяμвŁ►
    By Name and By Nature

    i know nothing but i know everything about it
    please take everything i type with a pinch of salt i am only learning this stuff as i go along. Please make a post helping someone else
    Want to post a small screen shot? Try MrExcel HTML Maker
    How To Install MrExcel HTML Maker: https://www.youtube.com/watch?v=Jycv...ature=youtu.be

  9. #9
    New Member
    Join Date
    Dec 2014
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    Hi AkaTrouble, the original code is here http://www.mrexcel.com/forum/excel-q...opy-paste.html

  10. #10
    Board Regular Teeroy's Avatar
    Join Date
    Nov 2012
    Location
    Sydney, Australia
    Posts
    2,240
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how can I re-enable copy/paste

    See your other thread for a solution.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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