| 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? |
| 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 | |||
Threaded Mode
