Hi all:

I am trying to Hide a range of columns from un-qualified users while making
them password accessible (viewable and editable) to permitted users. (It is
data that should be viewed by some of a club's Executive members only.)

So far I have done the following by macro:

Unprotect sheet
Unlock everything
Lock the restricted columns
Hide the colums
Protect Sheet On with Column Format Off (False - unchecked)

I get two problems:
1) Format columns is greyed out for every column -- I want users to have
access to width etc. for the non-restricted (unlocked) columns.
2) When I try to UnHide I keep getting : "Run-time error '1004':
Unable to set the Hidden property of the Range Class".

Stupidity question: Just double checking -- (I have been playing around
with this issue for so long I think I am in a double-think stupidity loop
brought on, in part, by double negatives). When an example shows 'object
Password = "secret", "secret means any password I want to make up, right?
Also, if I type a "secret" that secret password stays at the macro level,
i.e. it doesn't get saved in some password file, right?

Regards Bill