Password Protecting Cells

[Kevin M]

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

 

[Gord Dibben]

Power Unit and Oiler are simple..............just tools>protection>protect
sheet with a pasword.

Bowl Assembly requires a bit more work.

Select K:T and format>cells>protection 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