Simple Open Macro Button

Hello just new to whole visual basic macro programming was wondering if someone is able to help me.
I am creating a simple macro button in excel that simply opens a file that is stored in my Document as you can see from my code below

Please Login or Register  to view this content.

This works without any problems however if I close the excel program, it doesn't remember any macros, whenever you run the macro button in the ribbon.

Also is there a way to stop comments such as below to appear while running macro.

Please Login or Register  to view this content.

Thanks

Yes have added it to the ribbon for excel 2007.

But whenever close the excel program then open it again later on, it doesn't recognises the macro, as no longer available.