How do I enable copy in a protected workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a password protected sheet in Excel 2003 with locked cells. Copy and
paste is disabled but I'd like for this to remain available. How do I get
both protected cells and the copy paste function to work?
 
Not possible, you have to unlock the cells you want to copy from and paste
into
Can't have the cake and eat it
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
How to enable Copy and Paste when the sheet and workbook is protected 1
Protect Cells 10
Enabling Autofilter and Sorting in a Protected Sheet 2
protect cell format 1
Locking Down Workbooks Properly & Disabling Functionality 2
HOw can I copy a protect cell to paste somewhere other than excel? 1
corrupted formula in protected worksheet 21

Back
Top