View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default Lock cells, but still be able to trace

what is wrong with tools protect sheet?

remember that you have to do cells format protection first to determine
which cells will be locked.

but if you just do tools protection protect sheet there are plenty of
options there for you to define what your users can and cannot change in the
locked cells.

--
Allllen


"Johannes" wrote:

Dear all,

Is there someway to protect your worksheet cells, or at least the formula's
in it, but leave the rest open. One should not change the content (being the
formula), but should be able to do things like:
- Formatting of cell
- Formatting of row / column
- Hide column / row
- Use replace-functionality
-

Thanks,

Johannes