OLE object without border?

  • Thread starter Thread starter IBraun
  • Start date Start date
I

IBraun

Hello!

If I insert a OLE object (ChemDraw; either via VBA or by dialog) into a
excel spreadsheet, it is drawn with a black border around it. I can turn
the border off with the dialog - but how can I set this as the default?
Or can I influcence this by VBA?

Thanks for helping me!

I. Braun
 
Hi,

Why not record a macro turning off the border and
then with some minor tweaking, you'll have it?

jeff
 
Why not record a macro turning off the border and
then with some minor tweaking, you'll have it?
Click to expand...

Sometimes your're blind... Thanks. Here is what I got from the macro...

Selection.ShapeRange.Line.Visible = msoFalse
 
Back
Top