Hi

When building a sub-menu, how can I find out what the <Before variable
should be where there may be other Temporary menu items already in the sub
menu before this is created - if say I want to have the sub-menu appear just
before Paste Special (say), how can I know which number that should be - I
am looking for a technique here not just a number for that instance

Hope that makes sense (hopefully!)

Thanks

Tim



With Application.CommandBars("Edit").Controls.Add(tempo rary:=True,
Befo=9)
.Tag = "PasteBanklineStatement"
On Error Resume Next
.Caption = "Paste Bankline Statement"
.OnAction = ThisWorkbook.Name & "!Pasting_Statement"
On Error GoTo 0
End With