rangudu_2008
12-23-2008, 10:27 AM
I've an excel workbook shared among various users. This workbook contains sheets for each user which they use. Is it possible to restrict write-access (disable editing) to other sheets apart from the sheet allotted/used by a user? In simple words, they should only be able to view the contents of the other sheets updated by others while should not be able to modify the contents. They should be able to use only the sheet allotted to them.
Only one power-user should be able to make changes to all sheets in the workbooks while all other users must have the type of access mentioned above.
Can this be implemented in Excel? I'm using Excel 2003.
Ranga
Only one power-user should be able to make changes to all sheets in the workbooks while all other users must have the type of access mentioned above.
Can this be implemented in Excel? I'm using Excel 2003.
Ranga