I have a work book of ten sheets, I would like to paste one sheet to a word document as an icon. The problem I am having is that when I click on the top left corner of my sheet, do the paste special in word, choose a format that makes an icon, it pastes the whole workbook. I just need the single sheet. I click the whole sheet because I do not know how many columns of data I have in the work sheet. I really would also like to have the sheet in word be read only, like a picture if it din't paste the whole book. I may need a macro, but I have very little experience with VB, any help would be appreciated.


Will L.