Changing Permissions in Excel 2007

westrong · 05-14-2009, 09:42 AM

Is there a way to grant Read privileges for some employees and full editing privileges for others on Excel files without having to log in and out of the computer?

We want some employees to be able to look at our reservations without touching them and others to be able to add and delete from the same file.

**gistek** · 05-15-2009, 05:18 AM

I entered "Protect" in Excel help and selected
"Protect worksheet or workbook elements"
and
"Unlock specific areas of a protected worksheet"

I suggest at least skimming through these before setting protections and permissions.

Basically,

Protect the cells that some users may edit

Enter the user names of the people that have permission
Decide if those people will have to enter a password in order to edit. (if you allow editing without password anyone opening the spreadsheet on a computer logged in under that user name will be able to edit.)

Protect the entire worksheet

DON'T FORGET TO WRITE THE PASSWORD LIST SOMEWHERE.
There is NO way to recover lost passwords, so keeping a list is critical.

westrong · 05-15-2009, 02:27 PM

Thanks, I think that is just what I'm looking for.

05-14-2009, 09:42 AM	#1 (permalink)
westrong Registered User Join Date: Nov 2008 Posts: 6 OS: XP Home Edition	Changing Permissions in Excel 2007 Is there a way to grant Read privileges for some employees and full editing privileges for others on Excel files without having to log in and out of the computer? We want some employees to be able to look at our reservations without touching them and others to be able to add and delete from the same file. Last edited by westrong; 05-14-2009 at 09:43 AM. Reason: typo

05-15-2009, 05:18 AM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,912 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Changing Permissions in Excel 2007 I entered "Protect" in Excel help and selected "Protect worksheet or workbook elements" and "Unlock specific areas of a protected worksheet" I suggest at least skimming through these before setting protections and permissions. Basically, Protect the cells that some users may edit Enter the user names of the people that have permission Decide if those people will have to enter a password in order to edit. (if you allow editing without password anyone opening the spreadsheet on a computer logged in under that user name will be able to edit.) Protect the entire worksheet DON'T FORGET TO WRITE THE PASSWORD LIST SOMEWHERE. There is NO way to recover lost passwords, so keeping a list is critical. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

05-15-2009, 02:27 PM	#3 (permalink)
westrong Registered User Join Date: Nov 2008 Posts: 6 OS: XP Home Edition	Re: Changing Permissions in Excel 2007 Thanks, I think that is just what I'm looking for.