Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Protection > Protection Toolbar< Previous | Next > 

   

 

 Lock Cell - Prevents selected cells from being changed, moved, resized, or deleted. Locking cells has no effect unless the sheet is protected. Protect Form (Microsoft Word) Protects the current document from changes except in form fields or unprotected sections. To apply or remove protection from individual sections, click Protect Document on the Tools menu, click Forms, and then click Sections.

 
 

 Allow Users to Edit Ranges - Allows you to designate users, computers or groups who may make changes to the specified cells without entering a password.

 
 

 Protect Worksheet - Prevents changes to cells on worksheets, items in a chart, graphic objects on a worksheet or chart sheet, or code in a Visual Basic Editor form.

 
 

 Protect Workbook - Protects a workbook's structure and windows. You can prevent changes to the structure of a workbook so that sheets can't be deleted, moved, hidden, unhidden, or renamed, and new sheets can't be inserted. You can also protect windows from being moved or resized. When the active document is protected, the command name changes to Unprotect Workbook.

 
 

 Protect and Share Workbook - Protects the sharing and change history tracking in a shared workbook so the features can't be turned off. If you select this check box and click OK when the workbook isn't a shared workbook, you're asked if you want to save it as a shared workbook. In a workbook that's already shared, you can turn on protection for sharing and the change history, but you can't assign a password for this protection. To assign a password, you must first remove the workbook from shared use. When the active shared workbook is protected, the command name changes to Unprotect for Sharing.

 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >