Workbook macro to automatically create a custom menu button and assign a macro to it.

Hi there,

I'm currently trying to put together a macro that will create a custom menu button, assign a macro to it (which will make my userform appear) and then a separate macro that will delete the custom button when the workbook closes. The second macro is so that the custom button appears only in this specific workbook (I hope that's the right way to do it).

My problem is that I can't seem to figure out the code that will attach my macro to the button. Recording the manual process doesn't seem to record any code. Currently in the workbook I have the code:

Please Login or Register  to view this content.

This successfully adds the button. I'm guessing it's only one or two lines of code that I'm after. If anyone can help it would be greatly appreciated :D

Gareth