Excel 2003 Protecting a worksheet.

J

jay

Help!
I protected a worksheet and checked all boxes so that user can have acces to
all features such as copy, cut, format, edit, etc. (except the formulas).
It lets me do everything except Create a List and create Pivot Chart or Pivot
Table.

Any suggestions anyone? Thanks!
 
S

Simon Lloyd

What is it you want to be able to do?, if you want to do everything then
whats the point in protecting it?

jay;323313 said:
Help!
I protected a worksheet and checked all boxes so that user can have
acces to
all features such as copy, cut, format, edit, etc. (except the
formulas).
It lets me do everything except Create a List and create Pivot Chart or
Pivot
Table.

Any suggestions anyone? Thanks!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
Top