Macro execution refers not to the active sheet/excel file

  • Thread starter Thread starter blop
  • Start date Start date
B

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!
 
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.
 
Back
Top