I'm using Word version 2007.



I created a new command bar control that calls a macro like this:
With cbcNewMenu.Controls.Add(Type:=msoControlButton)
.Caption = "ConvertTable"
.OnAction = "mod100Procs.UpdateTable"

End With

The macro only works on the document that contains the VBA code. If I try to use it on any other document I get a "The macro cannot be found... message.

I've tried this:

With cbcNewMenu.Controls.Add(Type:=msoControlButton)
.Caption = "ConvertTable"
.OnAction = "'" & Thisdocument.name & "'!mod100Procs.UpdateTable"

End With

but that doesn't work. What am I missing?

Hi Don,

Ideally, you'd locate the macro in the document's template; otherwise you'll need to open the document holding the code before you can access it - and you'd have to reference that other document as part of the macro's call.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]