<div>
Hi,<br />
is your PC added / inside of a Active Directory domain?<br />
If yes, it might be that there is a Group Policy deployed which will set the various office settings from centrally managed configuration.<br />
<br />
HTH<br />
Rainer
</div>


Hi,
is your PC added / inside of a Active Directory domain?
If yes, it might be that there is a Group Policy deployed which will set the various office settings from centrally managed configuration.

HTH
Rainer

<div>
I had disable all unwanted addins now seems to be working ok.<br />
<br />
Thanks for the help.
</div>


I had disable all unwanted addins now seems to be working ok.

Thanks for the help.

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for jitendramehta's comment <a href="https://www.experts-exchange.com/questions/28230381/Excel-2007-Developer-macro-settings.html?anchorAnswerId=39506869#a39506869" rel="ugc">#a39506869</a><br />
Assisted answer: 500 points for ded9's comment <a href="https://www.experts-exchange.com/questions/28230381/Excel-2007-Developer-macro-settings.html?anchorAnswerId=39466214#a39466214" rel="ugc">#a39466214</a><br />
<br />
for the following reason:<br />
<br />
Some addins was causing the prblem after disableing addins now working ok
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for jitendramehta's comment #a39506869 [https://www.experts-exchange.com/questions/28230381/Excel-2007-Developer-macro-settings.html?anchorAnswerId=39506869#a39506869]
Assisted answer: 500 points for ded9's comment #a39466214 [https://www.experts-exchange.com/questions/28230381/Excel-2007-Developer-macro-settings.html?anchorAnswerId=39466214#a39466214]

for the following reason:

Some addins was causing the prblem after disableing addins now working ok

<div>
Hi jiendramehta,<br />
<br />
I think you have selected your own answer as accepted solution. If you see my first comment its says you need to disable addins.<br />
<br />
<br />
Ded9
</div>


Hi jiendramehta,

I think you have selected your own answer as accepted solution. If you see my first comment its says you need to disable addins.


Ded9

<div>
<div class="content wysiwyg-content">
I have Excel 2007 when i prepared new PC i go to Excel option, <br />
Trust Center, <br />
Trust center settings, <br />
Macro settings,<br />
I check box Enable all macro settings,<br />
Developer Macro settings,<br />
I check box Trust Access to the VBA project model<br />
<br />
For some reason after few days checkbox get unchecked for Trust Access to the VBA project model.<br />
<br />
Please help me what can change this settings automatically.
</div>
</div>


I have Excel 2007 when i prepared new PC i go to Excel option, 
Trust Center, 
Trust center settings, 
Macro settings,
I check box Enable all macro settings,
Developer Macro settings,
I check box Trust Access to the VBA project model

For some reason after few days checkbox get unchecked for Trust Access to the VBA project model.

Please help me what can change this settings automatically.

Excel 2007 Developer macro settings

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.