Q: not sharing sheets

[Guest]

Hello,
Here is my case. I have an excel workbook which a sheet per person. Now I
need to put this excel sheet into network and get people to access it. I need
to provide a way that people should not access to each others sheet. Now, I
know that I can achieve that if I create a file per sheet. Any other way?
Thanks,
Jim.

 

[Frank Kabel]

Hi
though you may create some code to hide specific sheets (and allow only
access after entering a user name + password) such kind of protection is
easily cirsumvented. So if this is sensitive data don't try to do this with
Excel. Sounds for me more like a database application

 

[Guest]

If I go with username/password, how should I handel it, is there any VB code
sample?

 

[Frank Kabel]

Hi
you may search the Google archives for this. But just think about the
scenario that the user disables macros -> Your code wont work