CATEGORY: Excel Security - Protection VERSIONS: Microsoft Excel 2007

Why it is important to protect a workbook? To prevent the structure from being changed. To prevent sheets from being deleted. To prevent new sheets from being inserted. To prevent hidden sheets from being opened. To protect a workbook: 1. Select Review -> Protect Workbook (in Changes Group). 2. Type a password in the Password box, and click OK. 3. Confirm the password, and click OK again.

Rate this tip 1 2 3 4 5   RATING: 1.00   VIEWS: 1515 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Monte Carlo Methods in Finance The Guide to Understanding Financial Statements Special Edition Using Microsoft Office XP Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed) Keys to Reading an Annual Report (Barron's Business Keys) The 11 Immutable Laws of Internet Branding

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books