PDA

View Full Version : adding access levels



niyrho
07-07-2008, 05:16 PM
Does anyone knwo how to add access levels on excel. I want to set it up so that when you try to open a file in excel it will ask for a name and password. And then I need each user to have different abilities. So if I sign in I can edit everything, one guy will only be able to enter information, and so on. If someone can just get me started, that would be awsome.

dominicb
07-08-2008, 03:04 AM
Good morning niyrho

I have a template available that users have to sign into with a password. Each user will only see the sheets that you, as administrator, have allowed them to. Access to the sheets will be either on a read-only or read-write basis, again this is fully controlled by the administrator, who will have full access to all pages.

This template is not 100% secure, but it will keep 99.9% of users in their place - Excel is not a secure development platform and if this is paramount to you, then perhaps you need to use a different application.

If you want a copy of this template, then PM me your e-mail address and I'll forward it on to you.

HTH

DominicB