Copy into partially protected excel sheet

[Zunit]

Hi,

I have an excel sheet with certain cells protected which I sent out to various branches/divisions to complete. They could only complete the unprotected cells.

Now I want to copy these sheets all into one workbook. This workbook should have separate tabs for each of the divisions sheets. This workbook also has the same format as the worksheets I want to copy from (with the same cells protected also).

I want to copy one worksheet at a time into the consolidated workbook. But excel doesn't allow me to do this because some of the cells are protected on both sides.

If I were to copy each unprotected cell at a time it would take forever to do. And I don't have the password to unlock the sheets/workbook.

Please help.

 

[Jerry Sullivan]

Nikki, I'm pretty sure that your error is due to a mismatch between your actual workbook and worksheet name and the ones in your code.
Those names have spaces, an underscore, a dot and parentheses - so there's lots of opportunity for a typo.
Check those carefully including any double spaces, trailing or leading spaces.