Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move or Copy" sheet
Hi,
I want to bring up the edit menu's "Move or Copy" dialog box via a control button. I've tried to record a macro to simulate the actions so I could see the code to do this but that did not work. I want the user to be able to insert the sheet into an existing file or a new workbook. The only reason I'm thinking this way instead of coding is because I'm a complete programming novice and am not sure how to do it. I'd need user input and all sorts of stuff so the user could select an existing file (if one exists) or open the template file and insert it into it and of course save it with the new name. This seems pretty overwhelming for me at this stage but, I'm open to learning if someone could help me through the process. As always, TIA. AFJr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move or Copy" sheet
Maybe use real template sheets (xlt) is a option to keep it simple ?
http://www.rondebruin.nl/sheettemplate.htm If not post back and we can help you to build another macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AFJr" wrote in message ... Hi, I want to bring up the edit menu's "Move or Copy" dialog box via a control button. I've tried to record a macro to simulate the actions so I could see the code to do this but that did not work. I want the user to be able to insert the sheet into an existing file or a new workbook. The only reason I'm thinking this way instead of coding is because I'm a complete programming novice and am not sure how to do it. I'd need user input and all sorts of stuff so the user could select an existing file (if one exists) or open the template file and insert it into it and of course save it with the new name. This seems pretty overwhelming for me at this stage but, I'm open to learning if someone could help me through the process. As always, TIA. AFJr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
Disable "Move or Copy sheet "action | Excel Programming | |||
Disable "Move or Copy sheet "action | Excel Programming | |||
name duplication via "Edit, Move or Copy Sheet" | Links and Linking in Excel |