Results 1 to 2 of 2

Thread: How to do Copy/Paste on protected work sheet in Microsoft Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    How to do Copy/Paste on protected work sheet in Microsoft Excel

    While using Excel I was trying to use the copy & paste option on one sheet which is protected but it won’t work. I have locked all the cells that have coding and protection for the worksheet, how can I allow a user to copy & paste cells together with its functionality. Can anyone please help me out? Thanks

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: How to do Copy/Paste on protected work sheet in Microsoft Excel

    The better question is how to disable copy/paste. Even with worksheet/workbook protection is enabled, you can copy the cells and paste them to a new workbook. If you want people to be able to paste into the protected workbook, don't protect those cells (note that formatting of the said cell could be compromised in this scenario).

Similar Threads

  1. Replies: 2
    Last Post: 24-02-2012, 07:22 PM
  2. Replies: 2
    Last Post: 24-02-2012, 07:18 PM
  3. Replies: 5
    Last Post: 24-01-2012, 01:10 PM
  4. Replies: 2
    Last Post: 14-01-2012, 03:29 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

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
  •  
Page generated in 1,675,686,092.55235 seconds with 18 queries