Copy from protected cell
 

I have acess to a file that is protected by someone else to aide with input.

I wish establish a separate file that pulls in data from this protected file.

It will not pull data from the protected cells of the other file.

Any ideas?

Copy from protected cell
 

Have you tried putting references in your workbook to the protected
book/sheet/cell and then using them to do any work you need to do with the
data?

The only other option, if you're actually opening the protected workbook to
do copy and paste is to unprotect the other workbook/sheets either manually
or with VBA code before beginning your copy operation.


"Glennw" wrote:

I have acess to a file that is protected by someone else to aide with input.

I wish establish a separate file that pulls in data from this protected file.

It will not pull data from the protected cells of the other file.

Any ideas?