I am writing a program using VBA because its readily available, the code will be available to Cracks even though I password protect it. I knew this when I chose VBA because portability is more important than protection. My question relates to copyright, I put copyright and my name in the code and on the spread sheet to indicate it is my program but is this enough when people start copying the code? Do you have a strong legal version which I could place in my code?
Copyright is Implicit
If it's personal, it's already copyrighted.
And something like what Matthew Foscarini gave you in his comment would do just fine to really make it clear:
Copyright 2013, Tony Royden, All rights reserved.
If it's you say you release copyright that it's not.
On the other hand, that just tells people you're the rightful owner of some stuff. Doesn't tell them what they can or can't do with it. That comes with licensing terms, which are up to you to define. They can range from "do whatever the hell you want with it as long as I can't be held responsible for it" to a "you damn kids get off my lawn, that's my stuff!". Or the GPL, but it's more verbose and complex to read and get.
Big Fat Caveat: There's No Universal Copyright Law
There are not that many universal laws of any kind, for that matter. This will vary from country to country. This is usually the accepted logic online though, as we mostly talk about US Copyright Laws and laws from countries that adhere to the Berne Convention defining some international copyright agreements.
Your mileage may vary, ask a lawyer.
(Of course, IANAL and stuff...)
In the US, if you created it, you already have a copyright on your work. There's a difference between owning a copyright and registering a copyright. So yes, for some purposes it's enough to put your copyright notice on your work and call it a day. If you think you might ever need to enforce your copyright, though, you may want to also register your work with the US Copyright Office.
Start by reading about copyright at the US Copyright Office's FAQ. If you decide that you want to register your copyright, there's a step-by-step guide on wikihow.com that will help. It basically walks you through the registration process.