Excel - Userwise Password and Profile Base Working

This query is : Resolved

Rangarajan (Querist)
Follow

08 July 2008 Hi Every one
I want to know whether the following can be implemented in Excel.
Mr. A using his user name and password can log into a workbook and view & make changes limited to his profile description. That is he is responsible for Sales, then he can only view or change only Sales and not other items.
At the Sametime Mr. B logs in with his user name and password and can view & make changes limited to his profile description.
The Accounts Manager can view all items using his user name and password.
Regards
Rangarajan

Rupert

Rupert (Expert)
Follow

10 July 2008 YES this can be implemented on EXCEL

1. If all persons plan to work in one workbook itself then, Learn more on Worksheet Protection for this feature that you need.

2. Otherwise all of you have to save files in the same folder and work in different workbooks and use workbook protection.

Learn more on these features of Ecxel through help & support available in Excel