having read a piece in an old forum entry on locking excel tabs and passwording them I was wondering if you could help me with problem I have. i have a worksheet were there is one master page and several other pages within the same workbook that all feed into it. the issue I have is that each of the other pages is completed by a seperate work colleague, 1 colleague per page. I have to protect each page so that each person is unable to view the others, to comply with data protection rules. this is a shared doc. is there anyway I can lock or password protect each tab so it inaccessible to other users?
your help would be most appreciated
your help would be most appreciated