Hi,

I am using the following code to allow users to insert a column into a protected sheet. The problem I have is that some of the original columns have conditional formatting and are locked. Is there a way of altering the code to insert a column without copying the conditional formatting/locking from the adjacent column?

Please Login or Register  to view this content.