I have a bunch of different worksheets with different macros that work
on the individual sheet. They all have the same name, and work
differently depending on the sheet.

I want to create a toolbar with two buttons, that calls macros in the
opened sheet, but I cannot seem to find my way around the problem I
encounter with excel not allowing me to call the macro using only
activeworkbook.macroname.

I don't want to paste all the macros into the addin I'm using, and
just detecting name of sheet to determin witch one to go with, so I'm
wondering what I can be doing wrong, and what I should be doing to get
this working.

So far I've been trying to work my way around this problem by
declaring the activeworkbook as an object, but that doesn't seem to do
it either.