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.


--
JFamilo
------------------------------------------------------------------------
JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276
View this thread: http://www.excelforum.com/showthread...hreadid=346085