Is this correct?
 

I am trying to have the workbook unprotect itself before closing and it
doesn't appear to be working. Here's what I'm doing. Is this the
correct usage of the Workbook_Beforeclose() function?

Private Sub Workbook_BeforeClose()
Application.Worksheets.Unprotect
End Sub

I'm thinking that maybe the worksheets keyword is wrong, should it be
workbook?

Thanks
Tracey


---
Message posted from http://www.ExcelForum.com/