ThisWorkbook.Activate Question
thisworkbook refers to the workbook that holds the code.
Look at the properties of the menu button and see which macro is assigned to
the button.
--
Regards,
Tom Ogilvy
" wrote:
I was given a spreadsheet for 1st Quarter with a drop-down ment that
calls a macro that recalcs all my pivot tables and one of the first
items in that procedure is ThisWorkbook.Activate.
I copied the whole workbook and made one for 2nd Quarter.
If I open the 1st Quarter one and the menu appears, and then I open
the 2nd Quarter one... there is still only one menu (as they are
exactly the same)... if I click the menu and run the macro, which
workbook will it run on?
I envision one of three possible answers: the first one I opened, the
last one I opened, whichever workbook was active.
Help!
|