I would like to set up a workbook that has multiple sheets with each being accessed by individual users through the use of a password for their respective sheet (e.g. manager 1 has only access to sheet1, manager 2 to sheet2 etc). However the workbook needs to be in a shared workbook environment i.e. multiple users having access at the same time albeit to their own sheet. The Protect Sheet option is disabled when shared workbook is enabled. Could someone please advise whether there is a work-around, I suspect through a VBA solution?
thanks