Passing a value based on selection on Ribbon

J

Judy@RMT

We used to use a global template, where a custom menu passed a value to a new
document based on CommandBars.ActionControl.Caption. When I attempt to use
control.id to pass the value, I get nothing. Presumably, when a new document
is created, the global template which contains the ribbon is no longer
active, and the control.id is lost.

Although I've been programming many years using VBA, I'm stumbling on how to
pass this value, and unfortunately the CommandBars.ActionControl.Caption
command is used at least 30 times in the original global template.

How can I make this work in Office 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top