Password protection

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2003

Password protection

Maria has attended:
Excel Advanced course

by - delegate Maria [1 post] (2008 Apr 16 Wed, 16:35) Reply

Which do you do first.... unlock a locked cell, or put the password protection on first?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Password protection

by - trainer Pete platinum contributer [799 posts] (2008 Apr 17 Thu, 08:17) Reply

Hi Maria, Thank you for the post, welcome to the forum, in answer to your question, always unlock the cell or range of cells before applying the worksheet protection, if you apply password protection first you will lock all cells. I hope that answers the question, if so please click the Resolved link, best regards Pete.

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Creating Charts with Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How to Create Better Excel Spreadsheets: Part Three
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips