Is it possible to add a button to a toolbar using VBA and also at the same
time add the macro for that button to a module

for exanple I have xreated an add-in that allows suers to automatically
connect to a common Essbase cube, what I would like them to be able to do is
to open a form enter their user name password essbase application and also
database then the button would be created and the macro would also be created
at the same time

I suspect it may not be possible

Thanks