Microsoft Office Forums - View Single Post - [Solved] cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc

Guessed · 10-30-2022, 01:29 PM

I don't usually have a problem with References unchecking themselves so I can only guess what might be happening on your machine.

Firstly, I would check that the code compiles correctly on her machine. If it works on a 32bit version of Word then you are 99% of the way there but there may be some code that fails to compile on a 64bit machine.

Secondly, verify which version of Excel she has on her machine. If it happens to be older that v16 then you should be able to reference Excel 15.0 instead.

Since the file you are transferring is a template which contains building blocks there shouldn't be a reason to also copy those building blocks to her Normal.dotm template. If you have code in your template that inserts those building blocks, just make sure the VBA gets the BBs from that template.