View Single Post
 
Old 05-26-2016, 07:36 AM
AndyF AndyF is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: May 2016
Posts: 1
AndyF is on a distinguished road
Default Disable all macros with notification - Office BUG !!!

Hi!

If i use activex checkboxes with some vba-sub's in a .dot or .dotm and generate a new document the vba-code for those activex checkboxes only works when the new file is primary open - it also works afer the new generated file is saved, but after close and reopen the file the activex checkboxes won't work.

By opening the new file the security warning "Enable Content" came - at this time i can see the reference to the .dot (or .dotm) in the VBE - after click on "Enable Content" it kills(!) this reference to the .dot (or .dotm) in the VBE an therefore no VBA-code of the .dot/.dotm will be found...and the next strange thing after the click on "Enable Content" is that the template is listed twice(!)....see the attachments

The only solution i found was to set the macro security settings to "enable all macros (not recommended; potentially dangerous code can run)" - with this settings everything works fine...is this really the only opinion?

OS: Windows 7 Enterpirse 64 Bit
Office: Microsoft Office Professional Plus 2010
Attached Images
File Type: jpg before enable content.JPG (20.9 KB, 19 views)
File Type: jpg after enable content.JPG (23.2 KB, 18 views)
Reply With Quote