Macro wont run with macros enabled

[tek0011]

I cannot seem to get this macro to run, even though all macros are allowed.
It will run from the actual macro screen but not the spreadsheet.

Ideas?

Or, better yet, is there a way to create a button like this, that will not require others to enable macros?

Edit: I believe I fixed this by creating another macro after macros were enabled.
However, will others that use this spreadsheet have to enable macros to use this button?