Protection.... after reprotect resets to defaults?

[Darin Kramer]

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 ***

 

[Ron de Bruin]

If you use Excel 2002 or 2003 there are protect options when you use
Tools>Protection..Protect Sheet

Record a macro when you check the options you want and look at the code

 

[Darin Kramer]

Thanks Ron

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