Protection

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

Resolved · Low Priority · Version 2003

Protection

Mary has attended:
Excel Intermediate course
Project Intermediate course

by - delegate Mary [2 posts] (2008 May 20 Tue, 16:35) Reply

How do you password protect a workbook?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Protection

by - trainer Simon gold contributer [214 posts] (2008 May 22 Thu, 16:10) Reply

Hi Mary,

Thank you for your question.

In order to protect a workbook, please follow these instructions:

1. File - Save AS.
2. Name the file and choose the location to save it in.
3. Then click on the Tools menu.
4. Select General options.
5. You can now enter two passwords if you want, one to open the workbook ad the second to modify it.
6. Then save the document.

To remove a password, once the file is opened, follow instructions 1,2,3,4 and highlight the stars in the password field and delete them so the boxes are blank. Then save the document.

I hope this answers your question.

Regards

Simon

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel in the Home Office
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Advanced Excel and PivotTable Reports
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Rate this page: