read only worksheet wanted.

  • Thread starter Thread starter Susan
  • Start date Start date
S

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?
 
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
 
Back
Top