hi,


i am creating an excel sheet from vb and importing some data in to it.
i want to lock that excel sheet so that the data in the excel sheet is
not changed.

pls help me.

Thanks in advance.

Suresh

The best way is to record a macro of Tools/Protection/Protect Sheet action!
You will then see in the recorded macro something like this:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Regards,
Stefi

"Suresh" wrote:

hi,


i am creating an excel sheet from vb and importing some data in to it.
i want to lock that excel sheet so that the data in the excel sheet is
not changed.

pls help me.

Thanks in advance.

Suresh