Hi,
I am trying to protect an excel sheet but allowing columns to be formatted.
recording a macro in excel gets me:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingColumns:=True
Doing various permutations to get the Progress code has failed me.
chWorkSheetrotect:AllowFormattingColumns=TRUE.
What is the correct format or can it not be done.
Thanks in advance.
Henry
I am trying to protect an excel sheet but allowing columns to be formatted.
recording a macro in excel gets me:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingColumns:=True
Doing various permutations to get the Progress code has failed me.
chWorkSheetrotect:AllowFormattingColumns=TRUE.
What is the correct format or can it not be done.
Thanks in advance.
Henry