qualitative
New Member
- Joined
- Aug 31, 2011
- Messages
- 1
Hi,
I have built an Excel tool that helps my coworkers create charts quickly. They are supposed to copy the charts and paste into Powerpoint as either links to the workbook, or pictures. However, some of them are doing it wrong and embedding the entire workbook into powerpoint as an msoEmbeddedObject (powerpoint VBA's keyword for it).
This is bad for a number of reasons. I have been looking around and am unable to find info on how to prevent this... is there some VBA code I can use to stop embedding? Is there some workbook setting?
Another option might be to put some code that only allows copying pictures from the workbook ("Copy As... Picture"). This page on ozgrid has some code that starts by preventing cutting and copying altogether, but I haven't used VBA to mess with copy/paste modes before, so I am unsure how to modify it to allow copying as a picture.
http://www.ozgrid.com/VBA/disable-cut-copy.htm
Thanks in advance for any insight!
Windows 7, Office 2010
I have built an Excel tool that helps my coworkers create charts quickly. They are supposed to copy the charts and paste into Powerpoint as either links to the workbook, or pictures. However, some of them are doing it wrong and embedding the entire workbook into powerpoint as an msoEmbeddedObject (powerpoint VBA's keyword for it).
This is bad for a number of reasons. I have been looking around and am unable to find info on how to prevent this... is there some VBA code I can use to stop embedding? Is there some workbook setting?
Another option might be to put some code that only allows copying pictures from the workbook ("Copy As... Picture"). This page on ozgrid has some code that starts by preventing cutting and copying altogether, but I haven't used VBA to mess with copy/paste modes before, so I am unsure how to modify it to allow copying as a picture.
http://www.ozgrid.com/VBA/disable-cut-copy.htm
Thanks in advance for any insight!
Windows 7, Office 2010
