Darin...

ClearFormats or Clear will set the locked property for a cell
to the 'default' from the style 'Normal' .

In most cases Normal style will have Locked set to TRUE.
.... thus your cells are locked again.


To avoid problems with automating protected sheets,
use the UserInterfaceOnly option of the Protect Method.

Be sure to read the remarks section in VBA help. You'll need to
Unprotect/Reprotect your worksheets on file open as that option is not
saved.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Darin Kramer wrote :

Anyone know why a locked sheet would not allow the following VB to
run - I get an error at the Selection.clear contents point (although
the sheet is locked only formulae are locked, and they are not near
these cells" Point of the formulae to is to delte (formats and
contents of 24c5 to 28c6

Sheets("Review Plan").Select
Application.Goto Reference:="R24C5:R28C6"
Application.CutCopyMode = False
Selection.ClearContents
Selection.ClearFormats

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!