I understand that the only way to protect project/macro is to open the VBA
Editor, go to the Tools menu, choose VBA Project Properties, then the
Protection tab. There, check the "Lock Project For Viewing" option and supply
a password. But VBA passwords can be cracked using software readily available
on the net.

I want to be able to distribute the spreadsheets with the macro but deny the
user access to the macro.

What would be the best/easiest way to create a standalone application? Could
the existing code be imported directly or would modifications be required?

Thanks