View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bigwheel bigwheel is offline
external usenet poster
 
Posts: 222
Default User-Level Sharing

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