Kim has attended:
Excel Intermediate course
Protection of Workbook
How can you unprotect an entire workbook rather than sheet by sheet?
RE: Protection of Workbook
Hi Kim,
Thank you for your question.
Did you mean Protect a workbook?
Save the file using Save As command. In the Save As dialogue box, go to Tools and then General Options. Create a password, confirm it and then save the file.
The next time you open the file it will prompt you for the password.
I hope this answers your question. If it does, can you please mark it as complete.
Regards
Simon