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.