98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Worksheet
Worksheet
Resolved · High Priority · Version 2003
Fri 23 Jan 2009, 10:57Delegate Priti said...
Priti has attended:
Excel Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Worksheet
Can you please let me know how I can password protect a worksheet on a workbook?
Is there a way in which each worksheet on a workbook can have a different password to open and edit?
Thank you
Tue 27 Jan 2009, 13:04Trainer Amanda said...
RE: worksheet
Hello Priti
Thank you for your question.
To my knowledge, you can only have a password set up to open a workbook, not individual worksheets.
You can password protect each individual worksheet against having changes made, using Tools - Protection - Protect Sheet.
Kind regards
Amanda
Tue 3 Feb 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |
