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?
.
|