in reply to Re: Excel Save & Cell Protect
in thread Excel Save & Cell Protect
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!
|
|---|