Worksheet.ProtectContents (Excel)

True if the contents of the sheet are protected. This protects the individual cells. To turn on content protection, use the Protect method with the Contents argument set to True.

Dim booProtectContents As Boolean
booProtectContents = ActiveSheet.ProtectContents