How do I enable copy in a protected workbook?

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?
 
P

Peo Sjoblom

Not possible, you have to unlock the cells you want to copy from and paste
into
Can't have the cake and eat it
 

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

How to enable Copy and Paste when the sheet and workbook is protected 1
Protect Cells 10
Pasting to Protected Cells in Xl2000 3
corrupted formula in protected worksheet 21
Ctrl Home disabled in protected worksheets 5
HOw can I copy a protect cell to paste somewhere other than excel? 1
Can't Drag a cell on a password protected sheet (Excel 2003) 4
Copy Worksheet of Locked Workbook 2

Top