Password protecting custom views

[rvalles]

I'm distributing reports to mutiple users who have different data access
privilages. This is not top secret stuff but I wanted to make inividual
custom views within the same file and have the access separated by
passwords. Does anyone know if this is possible? Even with some type of
Add-in?

Thanks,
rv

 

[J.E. McGimpsey]

There are a number of techniques you can use, and you can search the
archives to find some that will fit your needs:

http://groups.google.com/advanced_group_search?q=group:*excel*

Remember, though, the bottom line is that if your users are
moderately sentient (e.g., could they find their way to these
newsgroups?), and they have access to your workbook, they can gain
access to any sheet and any code inside.