You can search this newgroup for code that will break that approach. If you
give a user access to a workbook, plan on them seeing everything in it.

Protecting sheets or hiding sheets is designed to help the user not make
accidental alterations to the sheet/workbook. It doesn't provide any
security.

--
Regards,
Tom Ogilvy

"bigwheel" wrote in message
...
You could do this by hiding the user sheets, putting a button on sheet 1
with
instructions the when User1 clicks the button and supplies a password,
User1's sheet is displayed and similarly for User2, that sheet is
displayed.

"Thank you" wrote:

Hi everyone - very nice forum!
Is it possible to assign a set of specific parameters (either usernames
or
passwords) to a specific worksheets that are within the same Excel
workbook.

Basically, I would like to have User1 (with either username or password
of,
say, 'pswd1') to have access to only one specific sheet in a workbook.
User
with user name User2 (can be either username or login) to have access to
another sheet (other then User1) within the same workbook.

In other words:
User1 - can access only 'Sheet1' within 'Workbook0'
User2 - can access only 'Sheet2' within the same 'Workbook0'

As User1 makes changes to his 'Sheet1', he emails it to User2, who may
not
see or modify content of 'Sheet1', while User2 can modify his 'Sheet2'

if this can not be done in Excel 2003, plz recommend other applications
or
other ways