microsoft excel courses tate - Password Protection

Resolved · Low Priority · Version Standard

Password Protection

Rebecca has attended:
Excel Advanced course

by - delegate Rebecca [14 posts] (2007 Oct 17 Wed, 10:52) Reply

I have added a password protection to my document, however the user can still delete the contents. What can i do to resolve this?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Password Protection

by - trainer Richard platinum contributer [818 posts] (2007 Oct 17 Wed, 11:33) Reply

When you added password protection, did you lock the worksheet or the workbook?

You must protect the workbook to lock the contents.

Let me know

Richard

RE: Password Protection

by - delegate Rebecca [14 posts] (2007 Oct 17 Wed, 11:34) Reply

No I didn't lock the worksheet, how do I do this?

RE: Password Protection

by - trainer Richard platinum contributer [818 posts] (2007 Oct 17 Wed, 11:53) Reply

TOOLS > PROTECTION > PROTECT SHEET

Enter a password
Confirm Password

Done.

· MS Excel: Excel At Making The Most Of Your Christmas
· From the Classroom to the Corporate World
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Rate this page: