Sharing a Workbook But Restricting Access to Certain Sheets

[Brandy]

Here is what I am trying to create:
A workbook with 10 seperate sheets. Each sheet will be for a different
employee to enter certain information. I would like to make the workbook
accessible to each employee, but I want them to only be able to view their
sheet. I don't want them to view "Sally's" sheet and see her information. And
I want only certain cells within each sheet to be able to be edited by that
person. Does that make sense?

Is this doable??

Thanks,
Brandy

 

[akphidelt]

are familiar at all with VBA?

I wrote a similiar function to what you are trying to do that uses a
userform to accept a password.

The password is tested against a Select Case statement. And then it opens up
the specific sheet of whatever password is entered.

It uses xlVeryHidden to hide sheets and make it impossible to show them
unless you know how to get in to the VBA and manually change the code.

If you are able to understand this I can help you out further.

 

[Ron Coderre]

If the worksheets will contain any sensitive data at all, break up the
workbook and send the sheets individually. Excel's password protection is
really intended to prevent accidental access to protected areas. Users with
modest Excel skills who intend to access the protected areas will not have
much trouble getting to them.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Brandy]

I am somewhat familiar with VBA, but not to any great degree.
I need to be able to access every sheet and to correct data is needed.
Then I need the other 9 people to only be able to access the sheet with
their name on it. And then to enter their information in the appropriate
cell. And that's it.
Would this need to be saved on a network that every employee has access to?
So that when they enter their information they can save it for me to see?

 

[Kelly V]

Hello akphidelt!

What you have described sounds exactly like what I may be looking for. I
don't know if Brandy was helped by this, but I think I may need something
similar.

My boss has created a large Excel file that is absolutely dependant on
itself, i.e., there's no way to break up the sheets without affecting the
formulae in the rest of the workbook. It's an important doc that needs to be
viewed by many people, but it also contains some very sensitive info that
needs to be hidden. We've managed to figure out how to hide the 2 pages that
are sensitive, but even when we protect them with a password, they can still
be opened by anybody. Is there a way of letting people into the workbook but
restricting them from peeking at just those 2 pages?

Thanks in advance!
Kelly