Thank you in advance,
Les
Can be done with password protected sheets and some VBA code, but Excel's
internal security on password protected sheets is very weak.
Passwords can easily be cracked.
The passwording on VBA projects is harder to crack but can be done.
The general rule is........if you don't want someone to see data, don't include
it in the workbook.
Gord Dibben MS Excel MVP
first let me say thank you for your response. I am aware that security in
Excel is weak but it will be fine here since it will avoid confusion since
each person will only be able to open there sheet up. Along the lines you
were talking how would I go about setting it up? I dont need you to do it
for me but just some genreal dirrection. I am thinking that with what you
said I can apparently password protect each sheet? If so then why would I
need VBA code? 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?
Looking forward to your or anyone elses response.
Les
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:686tt21646gdo88c3...@4ax.com...
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 <ua39zZ8...@TK2MSFTNGP05.phx.gbl>,
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