View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
 
Posts: 76
Default password protection macro - HELP????

I have set up a workbook that protects and unprotects every sheet in the
workbook with the following macros: (My problem is that I want to allow the
user to enter comments into the protected worksheets and I can't figure out
how to get the protection macro to allow this.) I know it has something to do
with "drawingobjects=false", but I can't squeeze it in.--------Please Help:

Sub protect_sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="****"
Next ws
'
End Sub


Sub Unprotect_sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect Password:="****"
Next ws
'
End Sub