| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to activate original workbook?
I'm copying one sheet to an empty workbook with this code:
Sheets("Exported data").Copy This opens a new workbook beautifully. After this is done I want to return to the original workbook and hide the sheet "Exported data". How can this be done? Regards, S |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to activate original workbook?
Dim wb1 as Workbook
Set wb1 = ActiveWorkbook Sheets("Exported data").Copy wb1.Activate HTH Charles Chickering wrote: I'm copying one sheet to an empty workbook with this code: Sheets("Exported data").Copy This opens a new workbook beautifully. After this is done I want to return to the original workbook and hide the sheet "Exported data". How can this be done? Regards, S |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to activate original workbook?
Oops forgot the last half...
Dim wb1 as Workbook Set wb1 = ActiveWorkbook Sheets("Exported data").Copy wb1.Activate Sheets("Exported data").Visible = 0 'You can also set this to -2 to keep users from seeing this sheet in the unhide dialog Charles Die_Another_Day wrote: Dim wb1 as Workbook Set wb1 = ActiveWorkbook Sheets("Exported data").Copy wb1.Activate HTH Charles Chickering wrote: I'm copying one sheet to an empty workbook with this code: Sheets("Exported data").Copy This opens a new workbook beautifully. After this is done I want to return to the original workbook and hide the sheet "Exported data". How can this be done? Regards, S |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to activate original workbook?
Thanks a lot!
// S Die_Another_Day skrev: Oops forgot the last half... Dim wb1 as Workbook Set wb1 = ActiveWorkbook Sheets("Exported data").Copy wb1.Activate Sheets("Exported data").Visible = 0 'You can also set this to -2 to keep users from seeing this sheet in the unhide dialog Charles Die_Another_Day wrote: Dim wb1 as Workbook Set wb1 = ActiveWorkbook Sheets("Exported data").Copy wb1.Activate HTH Charles Chickering wrote: I'm copying one sheet to an empty workbook with this code: Sheets("Exported data").Copy This opens a new workbook beautifully. After this is done I want to return to the original workbook and hide the sheet "Exported data". How can this be done? Regards, S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return to Original Workbook | Excel Programming | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Original Workbook | Excel Discussion (Misc queries) | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| Returning to original workbook | Excel Programming | |||
Hybrid Mode
