Solved

Cannot enable Macros in Word 2007

Posted on 2008-09-30
12
4,540 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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
 

Author Comment

by:clcuser
ID: 22687923
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 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
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…
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…

785 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