Restricting Access to Parts of worksheet
I have a worksheet in Excel 2003. I have 7 users of this sheet and only want
them to be able to update cells relevant to them. I tried Protection/Allow Users to edit etc. but any help much appreciated. |
Restricting Access to Parts of worksheet
First you need to select all the cells in the workbook, and format cells,
protection, and uncheck the box marked "locked". Then select the cells you want locked, and format cells, protection, locked. Then you can protect your workbook. Steve "confused from Ireland" wrote: I have a worksheet in Excel 2003. I have 7 users of this sheet and only want them to be able to update cells relevant to them. I tried Protection/Allow Users to edit etc. but any help much appreciated. |
All times are GMT +1. The time now is 02:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com