User permissions in a single sheet???

[archive25]

Hello again people!

I'd like to know if there is a way to lock specific columns in a single sheet that are enabled with some kind of user permissions (password or sth like that..).

I'd also like to know if this is possible for both read only, as well as completely hidding the columns that the user is not entitled to see by his access rights.

Thank you all, in advance!

 

[archive25]

forgot to mention: i'm using excel 2000

 

[arthurbr]

Hello again people!

I'd like to know if there is a way to lock specific columns in a single sheet that are enabled with some kind of user permissions (password or sth like that..).



Thank you all, in advance!

Hi,
have a look at Tools - Protection - Protect sheet
Also lot of explanations in XL help.

as for the 2nd question, maybe with VBA?

Cheers

 

[archive25]

thank you arturbr. n fact i'm mostly concerned with a way to hide columns.

I'll check these out and come back if I need further help!