I've now fathomed out what I did in the first place.
When the Workbook was open, I clicked on the "Office Button" on the top left, then clicked on "Prepare" and finally on "Encrypt Document" and typed in my password. I just had to reverse this to remove the password.
But, I'll keep your suggestions in case I get into difficulty.
This thread is now locked and can not be replied to.