Tutorial 25: Worksheet Protection

Excel Video Tutorial 25 - Worksheet ProtectionThis 7 minute video tutorial provides guidance on how to set up "Worksheet Protection" and the circumstances in which it might be advisable. The key use for Worksheet Protection is to ensure that, in circumstances where Excel files are shared, users can only edit worksheets in ways that is intended by the worksheet originator. For instance, Worksheet Protection prevents the user from changing worksheet formula or format.

The video tutorial works through an example in Microsoft Excel and demonstrates how cells need to be unlocked if they are to be editable after Worksheet Protection.

 

 

 

 

Event Operations Manual
Software for Club Treasurers