Copying cells in a protected worksheet

R

Rohit

Hi,
I have a worksheet in which few of the columns are protected whereas others
are unprotected. these protected columns are in between unprotected columns.
I would like to copy data from an external souce to this worksheet without
unprotecting the sheet. Is it possible.

Thanks in advance
 
S

Shane Devenshire

Hi,

Just paste.

I suspect you are asking something more complicated than stated, but without
the details we can't help. For example are you trying to paste into a range
part of which is unprotected and part not, or are you trying to paste a block
of data only to the unprotected columns by skipping the protected ones? That
is you want to put the copied data into say columns A, D, F with one copy
command.
 

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

Dealing with the error: unable to filter on excel hc home school 0
How can I merge unprotected cells in a protected worksheet? 1
To protect all worksheet simultaneously in a excel workbook 1
I can still select & manipulate locked & protected cells in '07 1
Excel 2003 - how to check is all worksheet is protected 1
use source formatting with protected worksheet 2
inserting a picture into unprotected cells in a protected excelworksheet 0
Copying in sheet with protection with the use of a macro 5

Top