Thread: lock cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default lock cells

Alain,

Hide sheets 1,3 & 5 with format - sheets - hide and apply a password if you
wish.

For sheet 4 select all the cells you want users to edit and click format -
cells protection and remove the locked checkmark. Then protect to sheet with
tools - protection - protect sheet and apply a password.

Just one note of caution XL protection is not very robust and can be easily
cracked.

Mike

"--== Alain ==--" wrote:

Hi,

I have an excel file with 5 sheets and on each sheet some data.

I would like to avoid people to see some sheets.
For example, they can only see "sheet4".

Moreover, i would like to lock or restrict their rights.
They should be able only to update a range of cells (ex: B6:C50)

how can i do that ?

thanks a lot,
Al.