different passwords for each worksheets
 

I am creating a workbook for the risk assessment of our company. Based on
the risk assessment, I am going to have management and a few select
associates complete a risk assessment questionnaire that will link to the
risk assessment matrix. Each employee's questionnaire will be set up as a
different worksheet. However, I don't want any users other than me to be
able to view/modify the answers to another person's worksheet. Is there a
way to restrict access to each questionnaire to only the applicable user?
The only other option I can think of so far is to create separate workbooks
including only the questionnaire for each employee and link each workbook
back to the matrix in my main workbook. I know Access would probably be
better to use for this, but due to time constraints I'm going to have to go
with Excel for now. This is supposed to be ready to roll out this Friday.
Ahhh!!! Any suggestions would be greatly appreciated.

different passwords for each worksheets
 

Hi
Apart from setting up new workbooks, how about creating a Macro that hides
all sheets except the one the user requires !! The users password will then
access the appropriate sheet.
As for the code, I suggest far greater minds than mine will help there.
Maybe a new thread with this as the request will get you a result !!

Michael M

"jhucks8" wrote:

I am creating a workbook for the risk assessment of our company. Based on
the risk assessment, I am going to have management and a few select
associates complete a risk assessment questionnaire that will link to the
risk assessment matrix. Each employee's questionnaire will be set up as a
different worksheet. However, I don't want any users other than me to be
able to view/modify the answers to another person's worksheet. Is there a
way to restrict access to each questionnaire to only the applicable user?
The only other option I can think of so far is to create separate workbooks
including only the questionnaire for each employee and link each workbook
back to the matrix in my main workbook. I know Access would probably be
better to use for this, but due to time constraints I'm going to have to go
with Excel for now. This is supposed to be ready to roll out this Friday.
Ahhh!!! Any suggestions would be greatly appreciated.