Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Help I am Desperate (Excel 2002/2003)

    Hi

    Need help desperately I have turned of copy and paste and I can't get it back <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>


    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help I am Desperate (Excel 2002/2003)

    Have you tried quitting and restarting Excel? And if that doesn't help, restarting your PC?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Help I am Desperate (Excel 2002/2003)

    Hi Hans

    I used Task Manger to stop the process and rebooted and it came up OK.

    I was just trying to disable copy and paste for just one worksheet called "Input" and allow cut and paste everywhere else.

    Hence the saying "A little knowledge can be a dangerous thing" <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help I am Desperate (Excel 2002/2003)

    Was this related to your question in <!post=Prevent copy and paste in one worksheet (Excel 2002/2003),621337>Prevent copy and paste in one worksheet (Excel 2002/2003)<!/post>? If so, it would also have been possible to restore copy/paste by running the EnableCopy macro from the attachment to <post:=621,345>post 621,345</post:> in that thread.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Help I am Desperate (Excel 2002/2003)

    Hi Hans

    The answer to your question is yes, but I stil have the problem that in 2002 I get this error, Application.DisplayClipboardWindow = False <<< error here

    However I will live with that.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help I am Desperate (Excel 2002/2003)

    As I noted in that thread, you can simply delete or comment out that line.
    Moreover, that line is not in the EnableCopy macro, so you should be able to run EnableCopy in both Excel 2002 and 2003 anyway.

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Help I am Desperate (Excel 2002/2003)

    Hi Hans

    Point taken, with your guidance I now have it working to my satisfaction.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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