Ben,
Let me try to explain a little more to see if we can nail this down.
You say:
If I check the Tools protection option it shows nothing as having a password only the option to set one.
This has nothing to do with your macros.
Tools>Protection is for the Workbook, and is not an option in the
Visual Basic window.
So for now, forget about the "workbook" itself. Concentrate on the Visual Basic window for thiis workbook.
As John,Tina, and I are trying to say:
Your macros have been password protected at the VBA project level.
You will need the password to unlock the project.
With your workbook open, and the
Visual Basic window open, if you click on your Project
from the VB window, you say:
I get the message "Project Locked" at the top of an error box with "Project is unviewable"
This is telling us that your Project has been password protected by someone and this is why you cannot edit the macro.
The macros are ones I have written and have been using with this workbook for about 18 months.
1. Is it possible sombody else been in the Project and applied protection?
2. Could it be that you might have protected it and forgot that you did it?
And after reading your post from the bigining again, I would ask, What version are you running. Your messege box gives you the options of "OK" and "HELP"
My comments are based on Excell 2003. Where I get a slightly different message box when a project is protected. I get the options of, entering the Password, and two buttons "OK and "Cancel".
I don't know if that makes a difference. May depend on the version.
Harry