Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

password protection

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection

Password protection

ResolvedVersion Standard

Pat has attended:
Excel Introduction course
Excel Intermediate course

Password protection

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

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

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.