Excel protecting indiviual sheets within workbook

  ExcelDuck 21:21 10 Jan 2011

I am working with an excel spread sheet which is used as a time sheet on projects. The work book contains sheets for each employe working on projects

So there is a sheet for employee 1, then another sheet for employee 2 etc

I want to be able to protect the sheets so that employee 1 can only change their sheet, employee 2 can only change there etc also the employees do not have to enter passwords to access their sheets

Is there a simple way of doing this, as I can only see how to protect the sheets so nothing can change

Please help

  VoG II 15:01 11 Jan 2011

On each sheet select the cells which can be changed, press CTRL + 1 and on the Protection tab untick Locked. Then protect each sheet with a separate password that only you and the relevant employee know.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone