Hello,
I wonder if somebody can help me please.
I have a workbook with 6 sheets. I'd like to run a macro (macro1) that updates sheets 2-6 when I move from sheet 1 to one of the other sheets. I've tried to call macro1 with a Private Sub Worksheet_Deactivate() code on sheet1 but (as expected I guess ) I always end up on sheet 6 (the last sheet updated by macro 1) rather than the sheet I select to close sheet 1.
Is there a way I can get around this - is there VBA code for "go to selected sheet" I can put at the end of macro 1 or the Deactivate code?
Any help much appreciated.
Thank you,
Iain
I wonder if somebody can help me please.
I have a workbook with 6 sheets. I'd like to run a macro (macro1) that updates sheets 2-6 when I move from sheet 1 to one of the other sheets. I've tried to call macro1 with a Private Sub Worksheet_Deactivate() code on sheet1 but (as expected I guess ) I always end up on sheet 6 (the last sheet updated by macro 1) rather than the sheet I select to close sheet 1.
Is there a way I can get around this - is there VBA code for "go to selected sheet" I can put at the end of macro 1 or the Deactivate code?
Any help much appreciated.
Thank you,
Iain