Hello all, 

I have created a tool using word and VBA where a user selects the name of a company and it creates a letterhead based on data in an excel sheet. 

Briefly, there are three files involved. 

1) The creator tool – a word document with a create letterhead button which loads the name of the companies from an excel sheet

2) The company data excel sheet which the creator tool uses to find the company name and the other associated information that then gets passed to 

3) The master template word file – which is used to define where each piece of information from the excel sheets go. 

The users interact with the creator tool and end up with a new document with the right letterhead and address in it. 

All of the users of the tool are in the same organisation using M365. Users install the tool by copying two files to the C drive and the creator file to their desktop.

The issue arises when the user opens the creator word document for the first time. Unfortunately I can’t seem to find a way to prevent the document from opening with Design mode switched on, which makes the button on the document inactive. 

I’m looking to simplify the rollout without users having to enable the deliver ribbon, turn off design mode and then save – so any tips would be appreciated!

Thanks!

​Hello all,  I have created a tool using word and VBA where a user selects the name of a company and it creates a letterhead based on data in an excel sheet.  Briefly, there are three files involved.  1) The creator tool – a word document with a create letterhead button which loads the name of the companies from an excel sheet2) The company data excel sheet which the creator tool uses to find the company name and the other associated information that then gets passed to 3) The master template word file – which is used to define where each piece of information from the excel sheets go.  The users interact with the creator tool and end up with a new document with the right letterhead and address in it.  All of the users of the tool are in the same organisation using M365. Users install the tool by copying two files to the C drive and the creator file to their desktop. The issue arises when the user opens the creator word document for the first time. Unfortunately I can’t seem to find a way to prevent the document from opening with Design mode switched on, which makes the button on the document inactive.  I’m looking to simplify the rollout without users having to enable the deliver ribbon, turn off design mode and then save – so any tips would be appreciated!Thanks!  Read More

​