Protection

M

mac

Hello,
I was wondering if there is a way to protect a sheet, but be able to sort
the data? Does anyone know a way around this. Any help is appreciated.
 
W

William

Hi mac

To use code...
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True,
AllowSorting:=True

To protect manually...
"Tools>Protection>Protect Sheet" and select "Sort"and any other options you
want from the dialog box..

But what version of XL are you using?
--

XL2003
Regards

William
[email protected]
 
M

mac

Hi William,
I tried to manually protect and it does not seem to work. I am not sure how
to write the code. I am using excel 2003
 
Top