Protecting Excel Worksheet with a Password

Kim

Hi,
am trying to protect an excel worksheet with a password but am not quite sure where this code

XlWrkSht.Protect('Password',TRUE,TRUE,TRUE);

goes in the Excel Buffer functions.

Any Idea :idea:

ManosA

You can easily do it in excel itself (tools>protection...)

andrejsm

Notice. Excel password is only for 'dummies' users, because it could be cracked up in five minutes. It is not safe at all to use these office passwords.

Savatage

adding similar post link
http://www.mibuso.com/forum/viewtopic.php?t=12153