in reply to Re: Excel Save & Cell Protect
in thread Excel Save & Cell Protect

I tried the ALT+F11 with protect and got the following

Example

As it applies to the Chart and Worksheet objects.

This example protects the active worksheet. You can verify the worksheet is protected, by attempting to enter a value into any cell, on the active worksheet.

Sub ProtectSheet()

ActiveSheet.Protect Scenarios:=True, UserInterfaceOnly:=True

End Sub

This example protects the active chart. You can verify the chart is protected, by attempting to enter a value into any cell, on the active worksheet. This example assumes a chart exists in the application.

Sub ProtectChart()

ActiveChart.Protect Scenarios:=True, UserInterfaceOnly:=True

End Sub

This only shows how toprotect whole sheets or charts. I want to protect indivual cells. Therefore I guess I really do need the book!