Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cannot enable Macros in Word 2007

Posted on 2008-09-30
12
Medium Priority
?
4,580 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

636 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