This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
trust access to the vba project model not working in excel but it works in words, how to fix it?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Regards,
Edwin Tam
Excel Power Expander - http://www.vonixx.com
Thank goodness for System Restore then! What always gets me is how many times it seems to be needed from time to time by people and it just refuses to work, or says there are no available restore points (had those disappear once while I was in the middle of a restore - restore from one point failed, so I was going to use an earlier one, and all of them were gone!). Good luck with your project.
The important part of Edwin Tam's process is:
- Quit Excel and Restart Excel.
The settings for macro security do not take effect until you close and restart Excel.
Don't forget to change the setting back to "do not ..." when you are finished working with the workbook or else it will remain in effect on all other workbooks you open later. Allowing any other workbook to have access to the VBA Project creates a very real security issue.
the problem is i'm not able to check the checkbox bec. it is not accessible, it greyed. i'd tried to restart not only the excel but also my computer but doesn't work.
I do SYSTEM RESTORE. It is ok now. And reinstall all affected program.
Anyhow thanks for your replies.
The important part of Edwin Tam's process is:
- Quit Excel and Restart Excel.
The settings for macro security do not take effect until you close and restart Excel.
Don't forget to change the setting back to "do not ..." when you are finished working with the workbook or else it will remain in effect on all other workbooks you open later. Allowing any other workbook to have access to the VBA Project creates a very real security issue.