Right on the mark JE.

Exactly what I was getting at.

Add one point.................when saving/closing make visible a sheet with
message "You have disabled macros making this workbook unusable. Close and
re-open with macros enabled."

If macros enabled, message sheet will be hidden and user gets the password
inputbox to go from there.


Gord

On Sat, 24 Feb 2007 02:56:57 -0700, JE McGimpsey wrote:

I think that's what Gord meant. But I'll reiterate that if the
information is even remotely sensitive, find a different way, since you
only need enough technical savvy to find these newsgroups in order to
find ways to bypass all XL protection.

If it's just for user convenience, one way to implement it is to hide
all the sheets in the _BeforeSave workbook event, then use the
Workbook_Open event to display an inputbox asking for the user name,
then another input box to get the password. You could fancy it up by
creating a UserForm where both could be entered at the same time, and
the password field could be masked. After a successful match, unhide the
appropriate sheet(s).


In article ,
"Les" wrote:

Or did you mean that the VBA code would accept input from
the user and the code would unhide just the sheet that was tied to the
individuals password?