Excel tip: Make sure your sheet is protected
In his latest Excel tip article from AccountingWEB.com, David Ringstrom reviews the options for protecting the worksheet integrity in different versions of Excel.
Up until Excel 2003 there were two ways to determine if a worksheet was protected. The first involved attempting to modify a locked cell, which would trigger a warning message. Most seasoned Excel users will be familiar with the prompt that appears in when you try to modify a locked cell:
The second way to check a worksheet’s protection status involved choosing Tools-Protection, and looking for the Unprotect Sheet command.
To see the full instructions covering options for Excel 2010 and previous versions, register and log in to AccountingWEB.co.uk