Hi There

Im using "Sheets("Summary").Unprotect" and then
""Sheets("Summary").protect" at the start and end of a Macro. However
when I reprotect the sheet, the "qualities" specified (not in VB, just
by me manually selecting them) (see below) are not the same as before I
ran the Macro. Question is whats the VB to protect and unprotect a
workbook, but leaving the predefined qualities (see below) intact...?

Users can do anything except for :
1) Type over locked cells
2) Insert or delete rows or columns

Kind regards

Darin




*** Sent via Developersdex http://www.developersdex.com ***