Zee,

The following code should do it:

public sub unlock
for each sht in thisworkbook.sheets
sht.unprotect
next
end sub
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"Zee" wrote:

Unfortunately I am not very familiar with VBA and therefore am not sure what
to enter into the editor to accomplish this.

"galimi" wrote:

Zee,

You could use VBA to cycle through all the sheets that are protected and
unprotect them that way. Don't think it is possible without code.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Zee" wrote:

Is it possible to unprotect all sheets in a workbook at the same time?