Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing the selected tab in a worksheet_deactivate macro
HELP! Here's what I need to do.
On deactivating a particular worksheet in a workbook, I need to run a complex update macro (which I'm having no trouble with). Problem is this, to accomplish updating all the pages, etc. in the deactivate macro, I have to activate other sheets in the workbook. So, let's say, the deactivate macro is on Sheet1, and I do a bunch of stuff on Sheet2 and Sheet 3 during the deactivate macro, but I clicked on Sheet6, initiating the macro. At the end of the deactivate macro, how do I get it to go back to Sheet6 (or whatever sheet was selected? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing the selected tab in a worksheet_deactivate macro
The following should help
Private Sub Worksheet_Deactivate() Dim s As Worksheet Set s = ActiveSheet 'do your stuff here s.Activate End Sub If any of your complex updating involves selecting sheet1 (or the sheet which triggers this deactivate code) you could have a loop problem. Otherwise this should put you on the sheet you selected which triggered the deactivation of the sheet. Good luck. Ken Norfolk, Va ps Merry Christmas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to run on selected sheets | Excel Discussion (Misc queries) | |||
run macro when cell is selected | Excel Worksheet Functions | |||
Macro help in capturing server time | Excel Programming | |||
Macro to run in same row as selected button | Excel Programming | |||
Help : Macro for capturing current system time | Excel Programming |