Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What does InsertNameLabel & InsertNamePaste do? | Excel Discussion (Misc queries) | |||
What does label do under Insert, Name, Label? | Excel Discussion (Misc queries) | |||
how is Insert, Name, Label different frm Accept labels in formula | Excel Discussion (Misc queries) | |||
Insert | Name | Label | Excel Discussion (Misc queries) | |||
What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) |