locked
VB Project is not trusted. Excel Settings RRS feed

  • Question

  • Programatic access to Visual Basic project is not trusted error. I have a client I send a report to who is not comfortable (they say) in changing the settings to allow access (Office 2007). Does anyone know a work around that will allow the report to function? Alternatively any good information I can send them about the settings and their trustworthyness will do.

    Thanks

    Tuesday, May 15, 2012 10:21 AM

Answers

  • Allowing access to the VBA project object model is only required if you want to modify VBA code at runtime. Do you really need this?

    Regards, Hans Vogelaar

    • Marked as answer by Slam247 Tuesday, May 15, 2012 10:37 AM
    Tuesday, May 15, 2012 10:27 AM

All replies

  • Allowing access to the VBA project object model is only required if you want to modify VBA code at runtime. Do you really need this?

    Regards, Hans Vogelaar

    • Marked as answer by Slam247 Tuesday, May 15, 2012 10:37 AM
    Tuesday, May 15, 2012 10:27 AM
  • Thanks for the reminder. Have removed all references (was exporting to Powerpoint) and seems to be fine. As long as he doesn't intend to export any charts.

    Thanks again

    Tuesday, May 15, 2012 10:38 AM