read only worksheet wanted.

[Susan]

I see that it is possible to make an excel spreadsheet
read only. Is it possible to do this (make a workbook or
a worksheet read only) via a macro statement?

 

[CLR]

Hi Susan..........

I just recorded one and it came out like this..........

Sub readonly()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
End Sub

Vaya con Dios,
Chuck, CABGx3