Excel - Sheet Protection with Password

rkaufmann

Hi,

I want to protect an Excel Sheet after exporting data to this sheet.

To protect the sheet is not a problem, but I did not manage to set a password for the protection.

Has anybody a solution for this problem?

Thanks,

Rolf

Savatage

Does this help?

//Protect entire sheet
xlSheet.Protect('YourPassWord',True,True,True);

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=7301

rkaufmann

Hi,

thanks for that.

Simple solution, and ...

It Works.


Sorry for that late reply, but I was quite busy the last few weeks.


Thanks,
Rolf

Savatage

Another satified customer

I wish everyone would put the [Solved] in - thanks