View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sune sune is offline
external usenet poster
 
Posts: 2
Default insert label in worksheet



Hello

I try to insert some labels in a worksheet and it works but I can't
change BackStyle to fmBackStyletransparent.

I use this code to insert the labels
ActiveSheet.OLEObjects.Add(ClassType:="Forms.Label .1", Link:=False, _
DisplayAsIcon:=False, Left:=yy, Top:=xx, Width:=102.75, Height:=
_
69.75).Name = "newLabel" & yy & xx

After I insert them I need to set BackStyle to fmBackStyletransparent
and later, if it's possible, I want to delete them.
Is there solution for that?
Sune

*** Sent via Developersdex http://www.developersdex.com ***