I have such a file. Are you un-protecting the file before trying to run the macro? Otherwise Excel sees running the macro as an attempt to change a pw-protected file and balks at running it.

I type in the pw each time I want to run the macro. Usually I'm not making changes to this file so I just close without saving, which saves the hassle of re-protecting.