Copying locked cells and retaining the lock

[VAKaren]

So here I am trying to create a new spreadsheet for an expansion of a business. I'd like to open a new location and provide the same tooling in Excel for this 2nd business. The existing spreadsheet has locked cells so that employees can't mistakenly overwrite important data. When the copy is performed all the locks are gone and I have to recreate the lock. I would prefer to not have to edit each cell to recreate the lock. Is there a way to do this?

[dilipandey]

Hi VAKaren,

Welcome to the forum.

Instead of copy data (copy entire sheet), just right click on that sheet and choose move / copy as per your choice and this will retain the locking. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>