The problem is that you are embedding a worksheet so if you double click it you are back to the source worksheet. Paste as bitmap with the link option set. It will shrink to fit the space available, and being a link, any changes you make in Excel will be available to the document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|