View Single Post
 
Old 03-09-2019, 12:12 AM
aussiew aussiew is offline Mac OS X Office 2016
Novice
 
Join Date: Mar 2019
Posts: 3
aussiew is on a distinguished road
Default Assigning Macro to Drop Down list Content Control

Hi,

I have the following:

A document I sent to a customer when they select one of the 3 products. The 3 products are nicely listed in a 3 column table. I have a 3 column table depicting the 3 products with grey font color. If the customer selected product 1, I am formatting the table to change the font color to black for the selected product in this case column 1.

I am trying to do the following:

I inserted a Drop Down list Content Control object in the document and added 4 Items in drop down list. Prod1, Prod2, Prod3 and "Select Product".

I also created a macro that will select a column from a table in the same document and change the font color of the selected product. the macro works fine but I cannot find a way to assign this macro to the Drop Down List. I do not wish to use the legacy drop down list because I tried this and the document needs to be protected, which introduces other issues.

I would appreciate some guidance or anyone pointing me out to a similar thread.

cheers

aussiew

Last edited by aussiew; 03-09-2019 at 06:20 AM. Reason: assigning macro to Drop Down list Content Control
Reply With Quote