Password protect a file.

[Dedes]

Hi,

I am doing a project for my work and I don't want anybody to see how I am creating it.

My file has one sheet that is protected and also the VBA code is protected.
The sheet that is protected has a VBA module with the code below in order to let a macro change some values on that sheet.
Sheet5.UnProtect Password:="xxxxxx"
Sheet5.Protect Password:="xxxxxxxxxx"

However today I was surprised when a friend told me he could crack my file in 5 minutes.
I am very desapointed.

Is there any further way of proteting the file and making it impossible to crack?

many thanks
Dedes

 

[Smitty]

Dedes,

Unfortunately, Excel isn't a secure application, nor has it ever been marketed as one. Think of Excel protection like locks on doors: all they do is keep honest people honest. It's generally good enough for about 99% of the population, but if someone really wants to get past it, they can do so relatively easily.

Fortunately, both VBA and workbook protection are harder to break than worksheet protection, but they are still vulnerable. If you really need something secure and distributable, I'd do a Bingle search for "Excel compiler". If I recall there's still at least one good offering out there.

HTH,