CODEWITHSUNDEEP
vbatemplatesms-word
FlatCode
FlatCode

Reputation: 23

VBA code in a template

In a Word template I have a command button with VBA code behind it.

The problem is that the code gets lost when a document is created using that template. The button is still visible, but the VBA code behind it disappears for some reason. This causes the button just to be clickable without performing any action.

The documents are saved in .docx format.

How can I 'glue' the button to its code so it doesn't get lost ?

Upvotes: 2

Views: 1628

Answers (2)

Jean-François Corbett
Jean-François Corbett

Reputation: 38551

First, make sure your VBA code is saved in the .dotm template that you make available to everyone (and not in your personal normal.dot/dotm template — this is only available on your machine).

Then, make sure the documents generated from the template are saved as .docm (not .docx).

.docx documents cannot contain VBA code. Anything saved in .dotx or .docx format will, by definition, lose all VBA code.

In a comment you say

"this doenst matter, as the document is just used for the macro."

This is incorrect; it does very much matter. .docx documents can't "be used for" macros because they can't contain macros.

Upvotes: 3

nickand
nickand

Reputation: 127

For the macro to be always available, you need to store the macro in the normal template.

For example when recording a macro, select All Documents (Normal.dot) on Store Macro in.

Upvotes: -1

Related Questions