|
Forum home »
Delegate support and help forum »
Microsoft Excel Training and help » Password protection
Password protection
The UK's most regular instructor-led training courses.
Training information: excel training
· Excel training london
· Microsoft Excel Training UK
See also
· excel-courses-london
· excel courses in london
· excel microsoft training  Resolved · Low Priority · Version Standard
Password protection
 by - delegate Pat [10 posts] (2008 Mar 28 Fri, 16:15)  Reply
I'm sure this will be covered when I attend the intermediate course but in the meantime....
I know how to password protect a workbook/sheet but how can I protect the complete folder please?
Many thanks
Pat
RE: password protection
Hello Pat,
I hope you enjoyed your Excel training session with us.
In response to your question, while it is possible to password protect an entire folder, it does get a bit complicated, especially if you are on a company network, or on XP Professional. It is much easier to do on your home computer. If you have concerns about colleagues accessing files in a specific folder, you may want to ask your IT department to create a new folder for you that has restricted access. Until that point, I would suggest that you password protect the files individually, even though this is a bit of a hassle.
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
RE: password protection
by - delegate Pat [10 posts] (2008 Mar 31 Mon, 08:43) Reply
Many thanks for the reply and yes I did enjoy the course and can't wait for the next one.....
We are on a company network hence the need to protect. We have protected some of the files but as you say it is a real hassle and there are quite a few of them.
Is it so complicated that I wouldn't be able to do it? If you are able to give instructions I would be prepared to give it a try.
Regards
Pat
RE: password protection
Hello Pat,
I am reluctant to give you the instructions directly, as I do not want to conflict with any restrictions from your IT department. However, if you search on Google for "password protect folder", you will see the tips in the search results. The steps are not too difficult.
I hope this helps.
Regards,
Mara
Related articles
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part One
· Microsoft Excel Training Course
· From the Classroom to the Corporate World
Please browse our web site to find out more about
excel training and other Microsoft training courses. | Excel tip:
Use RANDBETWEEN to generate random numbers
There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.
The function looks like this:
=randbetween(LOW,HIGH)
where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.
This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:
=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).
where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).
One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.
View all Excel hints and tips |
|
Add to favourites
Printable version
Bookmark this page
Excel VBA 2 day course
[73 posts] (2008 Mar 31 Mon, 01:39) 
