View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
And1 And1 is offline
external usenet poster
 
Posts: 20
Default How to limit access to sheets ?? HELP ME

greet all,

We will suppose, that I work in the firm which be divided on several
sections.
Example:

DI - programmer
LT - Constructors
SD - purchases
FICO - finances and kontroling

Is about 10 sections.

I want to create file in Excel, they to which all with exchanged setions
will have access, but in limited method.
I want, to every of section had access to his sheet only. It can't open
different sheets. This very important.
The names of sheets will be the same as the name of sections.
Every of sheet (every section) should be protected by password.
I would want, to every user before open the file should be asked about
password. If it will write correctly ( will be 3 trial), suitable sheet
will open. If wrote incorrec file will close.


How to the best administer with passwords
Write it in code VBA ??
Maybe someone has different idea ?


Regards,
Andrzej