View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
 
Posts: 46
Default Unprotect workbook

Hi,
To unprotect a sheet with a click on a pushbutton I wrote:

Private Sub CommandButton5_Click()
Dim thing As Worksheet
For Each thing In Worksheets
thing.Unprotect
Next thing
End Sub

But what is the syntax to unprotect and protect a workbook?
Thanks