| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert New Sheet De-activates Current Sheet VBA Workaround?
When I insert a new sheet in a workbook, there are some things I do to it via
VBA code before it finishes activating. However, I would like to restore the sheet that was active PRIOR to the insert as the active one after the new sheet finishes it's setup. The events available in Excel don't seem amenable to this. How can I do this with VBA code? Thanks in advance, facmanboss |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Current Date on a Sheet 1 Tab | Excel Worksheet Functions | |||
| Preventing sheet name changes (or a workaround) | Excel Programming | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Programming | |||
| Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Threaded Mode
