Reassigning custom toolbar button functionality

In the interest of organization, I moved some subs to another module.
Trouble is, they were linked to some custom toolbar buttons. When I clicked
one those buttons, I got the "The macro cannot be found or has been disabled
because of your Macro security settings" warning box. In Excel, it's easy to
reassign a toolbar button. But I don't see the same "Assign Macro" menu item
in the Word customization pop-up menu that is in Excel.

Is there a way to reassign custom toolbar buttons? Or am I doomed to create
new buttons and assign them to the subs?

Word
Thu Jul 21 19:30:59 CDT 2005

G'day "Eric White" <EricWhite@discussions.microsoft.com>,

The easiest way is to redrag the routines up and copy the face over.
If you really must muck with your custom controls:

CommandBars("Menu name").Controls(n).OnAction="newmodule.macroname"

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Eric White reckoned:

>In the interest of organization, I moved some subs to another module.
>Trouble is, they were linked to some custom toolbar buttons. When I clicked
>one those buttons, I got the "The macro cannot be found or has been disabled
>because of your Macro security settings" warning box. In Excel, it's easy to
>reassign a toolbar button. But I don't see the same "Assign Macro" menu item
>in the Word customization pop-up menu that is in Excel.
>
>Is there a way to reassign custom toolbar buttons? Or am I doomed to create
>new buttons and assign them to the subs?
>
>

EricWhite
Fri Jul 22 08:43:01 CDT 2005

Thanks for the info. Will do. I was hoping there was some beautiful,
miraculously elegant way. Too bad someone hasn't come up with code that will
expedite the process. Guess I'll add that too my "to do" list. (The way
that list keeps growing, I'll have to buy SQL Server to manage it pretty
soon.)


"Word Heretic" wrote:

> G'day "Eric White" <EricWhite@discussions.microsoft.com>,
>
> The easiest way is to redrag the routines up and copy the face over.
> If you really must muck with your custom controls:
>
> CommandBars("Menu name").Controls(n).OnAction="newmodule.macroname"
>
> Steve Hudson - Word Heretic
>
> steve from wordheretic.com (Email replies require payment)
> Without prejudice
>
>
> Eric White reckoned:
>
> >In the interest of organization, I moved some subs to another module.
> >Trouble is, they were linked to some custom toolbar buttons. When I clicked
> >one those buttons, I got the "The macro cannot be found or has been disabled
> >because of your Macro security settings" warning box. In Excel, it's easy to
> >reassign a toolbar button. But I don't see the same "Assign Macro" menu item
> >in the Word customization pop-up menu that is in Excel.
> >
> >Is there a way to reassign custom toolbar buttons? Or am I doomed to create
> >new buttons and assign them to the subs?
> >
> >
>
>

Word
Mon Jul 25 07:43:29 CDT 2005

G'day "Eric White" <EricWhite@discussions.microsoft.com>,

LOL! I know the feeling mate :-)

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Eric White reckoned:

>Thanks for the info. Will do. I was hoping there was some beautiful,
>miraculously elegant way. Too bad someone hasn't come up with code that will
>expedite the process. Guess I'll add that too my "to do" list. (The way
>that list keeps growing, I'll have to buy SQL Server to manage it pretty
>soon.)
>
>
>"Word Heretic" wrote:
>
>> G'day "Eric White" <EricWhite@discussions.microsoft.com>,
>>
>> The easiest way is to redrag the routines up and copy the face over.
>> If you really must muck with your custom controls:
>>
>> CommandBars("Menu name").Controls(n).OnAction="newmodule.macroname"
>>
>> Steve Hudson - Word Heretic
>>
>> steve from wordheretic.com (Email replies require payment)
>> Without prejudice
>>
>>
>> Eric White reckoned:
>>
>> >In the interest of organization, I moved some subs to another module.
>> >Trouble is, they were linked to some custom toolbar buttons. When I clicked
>> >one those buttons, I got the "The macro cannot be found or has been disabled
>> >because of your Macro security settings" warning box. In Excel, it's easy to
>> >reassign a toolbar button. But I don't see the same "Assign Macro" menu item
>> >in the Word customization pop-up menu that is in Excel.
>> >
>> >Is there a way to reassign custom toolbar buttons? Or am I doomed to create
>> >new buttons and assign them to the subs?
>> >
>> >
>>
>>