Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to copy a user form from one workbook to a instruction manual. I just
want the form with no functionality oldjay |
#2
![]() |
|||
|
|||
![]()
Show the form.
hit alt-prtscr on the keyboard Open up your manual (in MSWord??). locate its new home hit ctrl-v (to paste) (Alt-prtscr just copies the active window to the windows clipboard) Oldjay wrote: I want to copy a user form from one workbook to a instruction manual. I just want the form with no functionality oldjay -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Hi Oldjay,
Open your workbook Select the cells you want to copy Open MS Word (or whatever program you are pasting the form into) Put your cursor where you want to insert Click Edit Click Paste Special Select Picture (Enhanced Metafile) Click OK This will insert your spreadsheet data as an image instead of as a table. I've done dozens of instructions manuals and it's always worked great for me. If you want to be able to link the information to the spreadsheet so that the manual gets updated when you update data in the spreadsheet, before clicking OK, click the Paste Link radio button. I hope this is helpful to you. Good luck, Pamela :) "Oldjay" wrote: I want to copy a user form from one workbook to a instruction manual. I just want the form with no functionality oldjay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
Copy shortcut | Excel Worksheet Functions | |||
How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) |