How to copy a row with formula in locked cells & insert copied cells in a protected sheet

**absorkhi** · 07-26-2014, 05:17 AM

hello
i Writhe this code and how to run in protect with password sheet

Please Login or Register  to view this content.

**RudiS** · 07-26-2014, 05:28 AM

Hi,

Welcome to the forum

You can use the following statements:

At the beginning of your macro use this line:

Please Login or Register  to view this content.

and at the end of the macro:

Please Login or Register  to view this content.

**rskfriends** · 07-26-2014, 05:29 AM

Hello absorkhi,

Formula:

Please Login or Register  to view this content.

please update your spreadsheet for better understanding.

**absorkhi** · 07-26-2014, 06:12 AM

i run this code into VBA but

Please Login or Register  to view this content.

this section

Please Login or Register  to view this content.

have error
what???

Re: How to copy a row with formula in locked cells & insert copied cells in a protected sh