is it possible to Hide certain worksheets from certain users?

[Guest]

is it possible to Hide certain worksheets from certain users?

if Yes which version of Excel offers this option?

 

[Bob Phillips]

there is no built-in facility, you would have to build it all (and it is no
simple).

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

It requires using macros, which may or may not work for you. You can
certainly find many ways in the archives:

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

However, in practice, you should assume that anyone that has access to
your workbook file can read the entire thing. Breaking internal
passwords is a snap:

http://www.mcgimpsey.com/excel/removepwords.html

and file and VBA protection isn't much better:

http://www.mcgimpsey.com/excel/fileandvbapwords.html