password for end user

[shane.allison]

Can you set a password for the end user to safeguard opening an excel
file from several users?

I know you can set a password for an excel file to OPEN or MODIFY, but
does the security hold the same when the user via email or a company
network looks at it?

Please help!

Thank you.

 

[Dave Peterson]

It should.

But I've seen some posts that say that the password disappears when they've
emailed the file. I've never seen this behavior. I can't duplicate it. I'm
not sure if the original poster(s) did what he/she explained. (I've always had
my doubts that excel/windows would behave this way.)

But there's nothing stopping you from doing some testing.

 

[JE McGimpsey]

The security, such as it is, in an XL file is the same no matter how the
file is transferred. However, it's rather easily defeated. See

http://www.mcgimpsey.com/excel/fileandvbapwords.html