Macro execution refers not to the active sheet/excel file

[blop]

Hi folks!

How do I tell a macro to work on the active sheet?
My problem is: I have created several macros and assigned to a toolbar.

When I move the excel file Excel everytime refers to the file where I
have assigned the macros to the toolbars...

Please help me! I have been sitting for a really long while trying to
solve this problem.

Thanks!

 

[Tom Ogilvy]

If you want the menu to use macros from the activeworkbook, you would have
to reassign them.

If you mean you have macros that need to refer to the activesheet, then use
the activesheet object in your code.