microsoft excel xp training - Sheet protection

Resolved · Low Priority · Version Standard

Sheet protection

Kerry has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Kerry [5 posts] (2007 Apr 4 Wed, 13:40) Reply

how can I protect my sheet from some users but not others? is it possible to set up different levels of protection for each user?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Sheet protection

by - trainer Tracy platinum contributer [586 posts] (2007 Apr 4 Wed, 14:43) Reply

Hi Kerry,

Thanks for the question.

Your options are:-

you can protect the sheet, whereby you can let other users access the sheet but not modify it.

you can partially protect the sheet by letting other users input into particular specified cells

or you can password protect the whole document thus letting no one even see you sheet.

These options are covered on your course today, but if you have any problems please let me know

Tracy