change header, footer information dependent on selection in drop down list
Hi,
I am wondering if it is possible to automatically change the header image (ship or airplane), footer document control name (document control: ship or airplane), and address (ship Ocean or airplane sky) by selection of drop down list.
Attached is an example.
Under Company, we have two options, either Ship or Airplane
Please advise VBA can do this.
Regards,
MK
|