Share via

trust access to the vba project object model

Anonymous
2013-11-27T00:00:24+00:00

trust access to the vba project model not working in excel but it works in words, how to fix it?

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-11-27T07:17:20+00:00
    • In Excel, go to Options.
    • Trust Center. Click "Trust Center Settings"
    • Choose "Macro Settings".
    • Check the checkbox "Trust access to VBA Project object model".
    • Click OK and OK.
    • Quit Excel and Restart Excel.

    Regards,

    Edwin Tam

    Excel Power Expander - http://www.vonixx.com

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2013-11-27T09:54:58+00:00

    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.

    0 comments
  3. Anonymous
    2013-11-29T01:01:07+00:00

    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.

    0 comments
  4. Anonymous
    2013-11-29T02:46:50+00:00

    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.

    0 comments