How much security do you need? Excel does possess adequate security features
to stand-up to a medium-large security attack.

Some basic ideas that are possible:
a) have a macro copy one sheet from master workbook into a new workbook.
b) In VBE, set visible property of other user sheets to "xlSheetVeryHidden"

But again, these are very weak security. The safest bet would be to split up
the workbook (See Ron's site for help on this:
http://www.rondebruin.nl/copy6.htm) and then place them each into folders
that only each user can access.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"McChas" wrote:

I have a workbook with 10 spreadsheets. Each sheet/tab is for individual
employees. Is there a way to have a user sign in and only view their own tab
and not gain access or even hide the other employees sheets/tabs?