I can`t add a macro to customize ribbon in excel

[Darren Smith]

Afternoon all

When I try to add the macro to the excel ribbon for some reason it won`t accept my macro?
Any idea why?

 

[RoryA]

What's the macro, and where is it? Does it require any arguments?

 

[Darren Smith]

It`s to open a User form
It`s in the works book Macros
Does not require any arguments

 

[RoryA]

Which module is it in, what is it called, and what exactly do you mean when you say that it "won't accept it"? What happens?

 

[Darren Smith]

Sorry in the mean time I`ve managed to solve this sorry to bother you.