View Single Post
 
Old 10-28-2022, 03:20 PM
grNadpa grNadpa is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Mar 2022
Posts: 46
grNadpa is on a distinguished road
Default cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc

I developed a word document with vba that uses an excel file. On my pc, the .docm resides in C:\Users\....\Documents\Custom Office Templates with the Developer>Tools>References>Microsoft Excel 16.0 Object Library Checked.
(I also set the Custom Office Templates folder as a trusted site.)

When I copy the .docm to my wife's pc's C:\Users\...\Documents\Custom Office Templates the Microsoft Excel 16.0 Object Library is not checked.

I enabled the Microsoft Excel 16.0 Object library through Developer>Tools>References> on my wife's copy and Saved. Multiple times. Multiple iterations.
But every time I open the .docm on my wife's machine, the Excel 16.0 Object Library is unchecked.

And the security warning continues to appear on each open.

What I want, of course, is that the Object Library to remain checked. I'd also prefer that the security message disappears.
Reply With Quote