Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() In my workbook, I have 2 worksheets. Sheet2 contains the raw data. Sheet1 is a summary level of the raw data containing many calculations, formatting, etc. I have VBA code that populates sheet2 with data from an external source on the Workbook_Open event. The last thing I want to do after populating the sheet is to set focus (or activate?) a different worksheet, in this case, sheet1. Can anyone tell me how to accompish this? I have searched Help till I'm blue in the face and can't think any more possible keywords. Any help is appreciated! Thanks! -- AaronC ------------------------------------------------------------------------ AaronC's Profile: http://www.excelforum.com/member.php...o&userid=21240 View this thread: http://www.excelforum.com/showthread...hreadid=377903 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |