LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What does InsertNameLabel & InsertNamePaste do? Studebaker Excel Discussion (Misc queries) 2 June 12th 08 04:13 AM
What does label do under Insert, Name, Label? trainer07 Excel Discussion (Misc queries) 2 April 18th 07 01:14 PM
how is Insert, Name, Label different frm Accept labels in formula ToniM Excel Discussion (Misc queries) 1 July 12th 06 03:49 PM
Insert | Name | Label Frederick Chow Excel Discussion (Misc queries) 2 June 26th 06 05:56 PM
What does Insert>name>LABEL option do ? Ali.Abbas.810 Excel Discussion (Misc queries) 1 December 5th 04 08:40 AM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"