Create an excel sheet, save it with password

[bclt]

Hi,

There is an application that creates an excel sheet. After finishing i save it to the disk so the user can watch it.

This i don;t know is how to password protect it, (tools -> protection -> protect sheet) with pass e.g "123".

By that any user may only watch it and print it (not add anything)


TNX

 

[udo321]

Hi, this works for me.

Dim pwd As Object = "password"
xlsheet.Protect(pwd)

But don't add the protection until you are finished writing your data to it.