ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   is it possible to Hide certain worksheets from certain users? (https://www.excelbanter.com/excel-discussion-misc-queries/24841-possible-hide-certain-worksheets-certain-users.html)

Admin

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?


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)


"Admin" wrote in message
...
is it possible to Hide certain worksheets from certain users?

if Yes which version of Excel offers this option?




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_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 ,
"Admin" wrote:

is it possible to Hide certain worksheets from certain users?

if Yes which version of Excel offers this option?



All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com