View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Password Protecting Cells

Power Unit and Oiler are simple..............just toolsprotectionprotect
sheet with a pasword.

Bowl Assembly requires a bit more work.

Select K:T and formatcellsprotection and unlock those columns.

Now protect that sheet with a password.

NOTE: Excel's internal security is very weak and passwords easily cracked.


Gord Dibben MS Excel MVP

On Sun, 25 Jan 2009 17:59:01 -0800, Kevin M wrote:

Hi Everyone,

I have a workbooke with 3 sheets, the sheets are called; "Bowl Assembly",
"Power Unit" and "Oiler"

I want to make the sheets "Power Unit" and "Oiler" read-only for everyone
but me and in sheet "Bowl Assembly" I want the colums a-j read only to
everyone but me and I want the columns k-t editable by everyone.

Can someone help me here...

thx.
Kevin M