Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit access to range of cells | Excel Worksheet Functions | |||
Limit access in a pivot table | Excel Worksheet Functions | |||
Limit access to certain worksheets (tabs) | Excel Worksheet Functions | |||
Limit access to certain worksheets (tabs) | Excel Discussion (Misc queries) | |||
Limit access to certain worksheets (tabs) | Excel Programming |