Q: not sharing sheets

J

JIM.H.

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.
 
F

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
 
J

JIM.H.

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

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
 
Top