Fabriziocan
New Member
- Joined
- Jan 28, 2017
- Messages
- 1
I made a Word macro-enabled template,that creates a chart in Word using VBA ( I created a reference to Microsoft Excel 15.0 Object Library in the VBE), based on responses users give. They tick checkboxes in the Word document.
So the user uses the template and should be able to produce a chart, in their document based on this template. Everything worked fine on my machine (I'm using Office 2013), when I create a document based, on the macro-enabled Word template, I tick the checkboxes and based on those responses click on the button, to create a chart, and I get a chart in Word.
However, when I sent the template to others, the other people, creating documents based on the template, who are using Word 2016, click on the button and can only see the Chart if they turn on Design mode in the Developer option. The minute they turn it off, the chart disappears - so it is there but hidden in design mode.
Any tips on resolving this issue would be appreciated.
So the user uses the template and should be able to produce a chart, in their document based on this template. Everything worked fine on my machine (I'm using Office 2013), when I create a document based, on the macro-enabled Word template, I tick the checkboxes and based on those responses click on the button, to create a chart, and I get a chart in Word.
However, when I sent the template to others, the other people, creating documents based on the template, who are using Word 2016, click on the button and can only see the Chart if they turn on Design mode in the Developer option. The minute they turn it off, the chart disappears - so it is there but hidden in design mode.
Any tips on resolving this issue would be appreciated.
