Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
move a sheet to another workbook
I need to move a sheet from one workbook to another workbook. I'd like to
create a button that uses a macro or vb script to accomplish this. I can create the move macro, but the catch is that the sheet that needs to move will have a different name every month. So I was thinking of the code popping up a form that I could type the sheet name in that needs to be moved and it will then move it. I'm familar with forms, text boxes, and basic VB, but need some help with the code here. Thanks for any help you can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
move a sheet to another workbook
Right -clicking the sheet tab and choosing "move or copy" does that already. If you must use a macro it sounds as if "ActiveSheet" is what you need.. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "phil-rge-ee" < wrote in message I need to move a sheet from one workbook to another workbook. I'd like to create a button that uses a macro or vb script to accomplish this. I can create the move macro, but the catch is that the sheet that needs to move will have a different name every month. So I was thinking of the code popping up a form that I could type the sheet name in that needs to be moved and it will then move it. I'm familar with forms, text boxes, and basic VB, but need some help with the code here. Thanks for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cursor does not move on one sheet in protected workbook | Excel Worksheet Functions | |||
move a sheet out of my workbook and place in another folder? | Excel Discussion (Misc queries) | |||
automatically move cell data in 1 workbook to another workbook | Excel Worksheet Functions | |||
Move the sheet tab bar to the top of the workbook? | Excel Discussion (Misc queries) | |||
I would like to move from sheet to sheet in a workbook using keybo | New Users to Excel |