Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
label control from macro
recently, i beleived that executing "recorded macro" must produce the very
*same* effect like the action was recorded but i found the difference for label form control inserting from control toolbox i created the label, and the recorded macro was: '------ ActiveSheet.OLEObjects.Add(ClassType:="Forms.Label .1", Link:=False, _ DisplayAsIcon:=False, Left:=416.25, Top:=114.75, Width:=157.5, Height _ :=78.75).Select '------ running that macro [on other worksheet] produced different result, that object missed the "properties" item from right-click menu also, macro didn't record the property editing [caption] that i did during label insertion is it expecting behaviour, or am i doing something wrong? i expected that recorded macro *allways* produce the same effect like the user interactive action? is there some workaround to got exactly the same result with macro and interactive action? thnx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Is it possible to Link a Label control to a cell ? | Excel Worksheet Functions | |||
Newbie: how to show the checked symbol in a label control | Excel Programming | |||
Format number as currency in label control ? | Excel Programming | |||
Label control - suppress GetFocus | Excel Programming |