teamsimpson
New Member
- Joined
- Sep 20, 2002
- Messages
- 22
i have an embeded object in sheet 1 of my worksheet, i use a hyperlink to another excell, to copy the contents of a worksheet, then i double click on the embedded object and then paste the data.
I have tried recording a macro, but it doesnot like double clicking to open an embeded object, so i edited the macro using OBObjects Activate, which works but i cant paste the contents of my clipboard and then close the embededobject.
I have tried recording a macro, but it doesnot like double clicking to open an embeded object, so i edited the macro using OBObjects Activate, which works but i cant paste the contents of my clipboard and then close the embededobject.