Hi Bill

Try this:
Cell A1: Look at this
Cell B1: EXTREMELY SECRET
Cell C1: information

Hide column B. Password protect the sheet.
Select range A1:C1. Copy
Go to another worksheet. Paste. What do you see ?

Do not include secret material in excel files. And if you have to, do not
include it in visible worksheets.

HTH. Best wishes Harald

"Bill Case" <Bill skrev i melding
...
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