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?
Sub WritingInsertColumntoleft()
' Unlock
ActiveSheet.Unprotect "numeracy"
'Insert column to the left of the active cell
ActiveCell.EntireColumn.Insert
' Lock
ActiveSheet.Protect Password:="numeracy", AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True
ActiveSheet.EnableSelection = xllockedCells
' Select
Sheets("Number & Algebra").Select
Range("A1").Select
Bookmarks