J
Jerrold
I'm trying to add an entry to the Insert menu in Excel 2003 but nothing happens.
The code I'm using in the macro is:
Set MyButton =
Application.CommandBars("Insert").Controls.Add(Type:=msoControlButton,
Temporary:=True)
MyButton.Caption = "Insert Confidential Header and Footer"
If I change "Insert" to "Edit", "Format" or "Tools" it works fine. Any idea how
to make it work in the Insert Menu? I can add items manually when I bring up
Tools-Customize without a problem.
The code I'm using in the macro is:
Set MyButton =
Application.CommandBars("Insert").Controls.Add(Type:=msoControlButton,
Temporary:=True)
MyButton.Caption = "Insert Confidential Header and Footer"
If I change "Insert" to "Edit", "Format" or "Tools" it works fine. Any idea how
to make it work in the Insert Menu? I can add items manually when I bring up
Tools-Customize without a problem.