Hi

In Excel 2002/2003 when you protect your sheet you have some options.

You can also protect your sheet with code like this
all macros are working then (97-2003)

Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="ron", userinterfaceonly:=True
End With
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl


"greensl" wrote in message ...