Excel 2003 permissions per sheet

[BudOlly]

Is it possible to setup different permissions for each sheet within the same
workbook? We'd like to give each user their own sheet containing their info,
but we do not want them to have access to view others' info. Can it be setup
somehow to use windows built-in authentication?

Thanks in advance for any suggestions.

 

[db]

it is doubtful that you can implement
such a methodology.

however, what you can do is to give
each employee their own workbook.

then have a master workbook that
links to all the employee workbooks.

the methodology above with a master
workbook would prevent users to
view each others work books.

--
db·´¯`·...¸><)))º>
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Accountancy
- Veteran of the Armed Forces
- @Hotmail.com
- nntp Postologist
~ "share the nirvana" - dbZen

~~~~~~~~~~~~~~~