anyway to protect formulas? without protecting WS or WB

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

i would like to protect all formulas but without turning protection on, this
is because i still need the user to be able to sort all the data. if
protection is on you cant sort locked cells. /me bangs head on wall!

Steve
 
Hi Steve

in later Excel version you can allow sorting then
protection is turned on. If this does not work for you I
don't see a way to protect formulas WITHOUT turning
protection on
 
i have excel XP sp3, i get an error msg saying something along the lines of,
some of the cells selected to sort are locked, you can not sort locked
cells.

Many thanks,
Steve
 
Back
Top