View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sali sali is offline
external usenet poster
 
Posts: 53
Default 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