?
Solved

Cannot enable Macros in Word 2007

Posted on 2008-09-30
12
Medium Priority
?
4,585 Views
Last Modified: 2012-05-05
Hi.  We are running Office 2007 in a Citrix PS 4.5 environment.  We have used Group Policy to enable the Trust Bar warning for all macros for Word.  However, when we try to open a file with a macro, we can see the bar, but a window pops up saying:

"The macros in this project are disabled.  Please refer to the online help or documentation of the host application to determine how to enable macros"

After I click on OK, the Trust Bar disappears and I'm unable to enable the macro.

Can anyone help with this?

Thanks.
0
Comment
Question by:clcuser
  • 6
  • 6
12 Comments
 
LVL 12

Expert Comment

by:GlennHarris
ID: 22608258
In 2007, you cannot have macros in a .docx file, it needs to be saved as a macro-enabled .docm file extension. Select the Office Button, Save As command, then change the file type to Macro-Enabled
0
 

Author Comment

by:clcuser
ID: 22681048
Thanks for the response.  Maybe I should provide a little more detail.

The file is a template from Avery.  The user tries to launch it by double-clicking on it and then we get the described behaviour.  How can we apply your solution in this case?

We were able to work around it by copying the macro to the user's profile.

Thanks.
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 22681236
I'd suggest you try using Office Button > Open > "Avery Template", then Office Button > Save As > Word Template
Before you click save, click on the File Type drop down that says "Word Template" and change it to "Word Macro-Enabled Template"; The file's extension should be dotm not dot or dotx.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

Author Comment

by:clcuser
ID: 22687331
Unfortunately, that didn't work.  I can't get it to open properly, so when I save it, I'm not saving the template with all the features enabled.  Oh well...
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 22687586
If you attach the file or provide a url to download it i'll have a look at the issue, my solution should have worked.
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 22688863
That template works fine on my computer. Make sure before you open the template that you've enabled macros; From the office button, click on the Word Options button. Click Trust Center on the left. Click the Trust Center Settings button toward the right side. Click Enable Macros radio button and check the Trust VBA model checkbox, then re-open the file.

HTH
0
 

Author Comment

by:clcuser
ID: 22689492
Unfortunately we have Group Policy settings to not enable macros by default.  The setting is "Disable all macros with notification".
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 22689688
So it sounds like you already knew your answer. If the template has macros and macros are disabled are you asking to hack the group policy? It'd seem easier to request an exception.
0
 

Author Comment

by:clcuser
ID: 22689940
That brings me back to my issue that I highlighted at the beginning where the trust bar disappears, so I'm unable to enable the macros.

When I open other Word docs that have macros, they are disabled, but the trust bar does not go away and I am able to enable the macro and work with the doc as expected.  
0
 
LVL 12

Accepted Solution

by:
GlennHarris earned 2000 total points
ID: 22691387
The avery template installs itself as a password protected locked addin so we cannot change it's behavior.
0
 

Author Comment

by:clcuser
ID: 22715148
Okay.  Thanks for your help.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question