?
Solved

Cannot enable Macros in Word 2007

Posted on 2008-09-30
12
Medium Priority
?
4,572 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

764 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