Macro Security

[nigelk]

Hi all,

I'd like to send out some spreadsheets that have a password to protect the vba code.

I know it was fairly easy to break the password in 2003. Is the 2007 version much more secure, or is it the same?

Has anyone any further suggestions on how to secure a workbook?

Thanks,Nigel

 

[Tuelor]

I've seen a website that plays around with sharing a workbook and locking the code, it maybe worth googling as it can help make sure your code is more secure.

If you can separate the spreadsheet and the code that may make things easier.

D