| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USER FORM COPY
how to copy /move a userform from w/book to another w/book?
how to copy/move only object from w/book to other w/book? how to copy/move only code of userform from one w/book to other w/book. copying/moving will affect userform controls's control properties? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200608/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
USER FORM COPY
Hi
Select the Userform and go to File, Export File... To import the userform to another workbook use File, Import File...This will bring the form and its code modules. If you don't want the code, delete it. The imported form should work OK, assuming any references exist in new workbook (custom controls etc) regards Paul tkraju via OfficeKB.com wrote: how to copy /move a userform from w/book to another w/book? how to copy/move only object from w/book to other w/book? how to copy/move only code of userform from one w/book to other w/book. copying/moving will affect userform controls's control properties? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200608/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User form in copy of original file | Excel Programming | |||
| copy sheets selected on user form | Excel Programming | |||
| copy sheets selected on user form | Excel Programming | |||
| Copy from User form to Sheet macro | Excel Programming | |||
| Copy one spreadsheet into another without activating second spreadsheet's user form | Excel Programming | |||
Linear Mode
