is it possible to Hide certain worksheets from certain users?

is it possible to Hide certain worksheets from certain users?

if Yes which version of Excel offers this option?

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)


"Admin" <[email protected]> wrote in message
news:[email protected]...
> is it possible to Hide certain worksheets from certain users?
>
> if Yes which version of Excel offers this option?
>

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

In article <[email protected]>,
"Admin" <[email protected]> wrote:

> is it possible to Hide certain worksheets from certain users?
>
> if Yes which version of Excel offers this option?