Nothing has changed but macros won't work!?!

[JFamilo]

I have written a few macros and sent them via a text file to a colleague. She has used these macros on several of her files by copying and pasting them into new modules. Once the macros are operable for that workbook we send them on to other users, that way they just need to click a button and it works.

This process has always worked well. But recently when she tries to run the Macro there is always an error. It has something to do with adding a button to a worksheet. It worked earlier and the code has NOT changed. This has happened on several occasions. Is there something unstable about macros that can be changed so they will always run without fail!?

Thanks in advance.

[JFamilo]

In an update to this....after working on this for a long time and restarting Excel, restarting the computer, retyping some code etc. we finally figured out the problem.

If you are assigning a button to a macro in a file, for example:
Set btn = ActiveSheet.Buttons.Add(l, T, H, W)
btn.OnAction = "Tennessee Policies Aug-2004!macro2"

Make sure the filename doesn't have a "-" in it! That turned out to be our problem


Hopefully I can save someone a lot of time with this.