View Single Post
  #4   Report Post  
Phyllis
 
Posts: n/a
Default

Thanks. I tried that and I get a message that the project
is locked, and it won't record the macro.
-----Original Message-----
Hi
only possible using VBA (first unprotecting the sheet,

then sorting and
protecting the sheet again)

--
Regards
Frank Kabel
Frankfurt, Germany
"Phyllis" schrieb im

Newsbeitrag
...
I have a worksheet that I've protected all the cells that
contain formulas so that other user's can't

inadvertently
delete them. However, I need to be able to sort the

data,
but it's not an option when the sheets protected. Any
suggestions?



.