Macro execution refers not to the active sheet/excel file
 

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!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Macro execution refers not to the active sheet/excel file
 

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.

--
Regards,
Tom Ogilvy

"blop" wrote in message
...
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!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/