I currently have a macro that if initiated copies a new table into a protected worksheet.
the blank cells in the receiving worksheet are not protected, so that it can receive it
when protecting the worksheet, I allow for copied cells and format changes
For some reason, it will not copy over the merged cells correctly when the sheet is protected.
If the sheet it not protected, it copies the merged cells just fine.
This is the same result when using the macro or doing it manual, so the issue is when the sheet is locked.
Below are the sheet protections.... Any ideas?
the blank cells in the receiving worksheet are not protected, so that it can receive it
when protecting the worksheet, I allow for copied cells and format changes
For some reason, it will not copy over the merged cells correctly when the sheet is protected.
If the sheet it not protected, it copies the merged cells just fine.
This is the same result when using the macro or doing it manual, so the issue is when the sheet is locked.
Below are the sheet protections.... Any ideas?