hi everybody -
this sub (on a toolbar button) worked perfectly well until yesterday:

=========================
Sub LockFormulaValidation()
'
' LockFormulaValidation Macro
' Macro recorded 8/25/2006 by Susan
'
With Selection.Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="="""""
.IgnoreBlank = False
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "FORMULA CELL"
.InputMessage = ""
.ErrorMessage = "No manual calculation allowed!"
.ShowInput = False
.ShowError = True
End With

End Sub
===========================

i was "locking" a large amount of cells in a workbook project. i
cleaned the project & also my personal.xls where this macro resides.
still won't work in that spreadsheet, but will work in others.

is there a limit to the # of cells in a worksheet (or workbook) that
can have validation??? didn't find anything in newsgroup
searching.....

thanks!
susan