restricting access to a worksheet?

I am using Excel 2000. I have a spreadsheet on a server that can be accessed
by approximately 50 people. There are 2 worksheets in this document that
contain sensitive information and I want to limit access to these worksheets
to only to a few users exclusively. Can this be done? Thanks!

How about require a user to enter a password.

This code will hide/unhide a sheet as needed. When you click on the button it will prompt you for a password then open if correct, when you click it again it will rehide the sheet.

Add a command button to a sheet and then right click it, click on view code and place this code into it. Make sure to change the command button name/number as needed and also change the sheet name/number accordingly. just make sure to password protect the VBA Project in the VBE so that the user cannot look at the code for the password.

Please Login or Register  to view this content.

Hope this will help.

Larry