OssieMac,

Appreciate your perseverance with this.

Unfortunately I need to solve this as it's affecting an LOB application
that's build on excel. The application progamatically copies the worksheets
so without even being able to manually copy the worksheet, the program won't
come close to working.

I've tried to highlight / copy the objects individually and this is strange.
It shows up in the Clipboard viewer, but i'm unable to paste it into the next
sheet. Other objects like individual cells copy / paste fine.

does that help at all?

Cheers


"OssieMac" wrote:

Hi again Lincoln,

I really don't know the answer but can you copy the objects individually? (I
know you don't want to do it that way but just for my curiosity). You may
need to be in design mode to copy some objects.

Also is this only for a particular workbook or are all workbooks (including
newly created ones) like it?

--
Regards,

OssieMac


"Lincoln De Kalb" wrote:

Hey OssieMac,

Appreciate the response but neither of those methods work.

In both cases everything will be copied to the new worksheet except for the
embedded objects and it doesn't matter what the embedded object i.e. wordpad
document, flash object, any OLE object. etc.

Cheers


"OssieMac" wrote:

Hi Lincoln,

How are you attempting to copy the worksheet? Are you right clicking the
worjsheet name tab and then select Move or Copy then in the dialog box
checking Create copy or are you simply clicking the point where the column
and row identifiers meet to select the entire worksheet then copy and paste
to another worksheet?

The first method should work. If using the second method, a lot of objects
will not copy unless you are in design mode when you perform the copy. Even
then, I am not sure if everything will copy.

--
Regards,

OssieMac


"Lincoln De Kalb" wrote:

Bump.

--
-= There''''''''s only one damn problem, it''''''''s not working =-


"Lincoln De Kalb" wrote:

Heya,

Have a problem where the copy worksheet function (manual or programatically)
wont copy over the embedded objects regardless of their type i.e. clipart,
OLE object etc.

It will work OK in Safe mode.

There are no:

Addins
COM Addins
Files loaded on startup (tools options general at start up.....)
XLB's or PIP's

I've also re-registered Excel with no luck.

I'm thinking it must be a security setting (macro level is set to low for
testing). I've inherited this SOE so really not 100% what's going on but
can't see anythign obvious.

Thanks in advance
Lincoln