Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Oldjay
 
Posts: n/a
Default copy userform

I want to copy a user form from one workbook to a instruction manual. I just
want the form with no functionality

oldjay


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default copy userform

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   Report Post  
pameluh
 
Posts: n/a
Default copy userform

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy tabs(sheets) from workbook without link to original source Rich Ulichny Excel Discussion (Misc queries) 3 August 25th 05 02:11 AM
Copy shortcut BJH Excel Worksheet Functions 0 August 10th 05 12:41 AM
How can I copy cell formats in functions? Twitty Kitty Excel Worksheet Functions 3 July 24th 05 12:26 AM
Copy sheet 1 data to sheet 2 cells. Tom Doggett Excel Worksheet Functions 1 July 19th 05 11:49 PM
Copy without Hidden Cols - How abrogard Excel Discussion (Misc queries) 1 July 15th 05 07:54 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"