View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Programmatically check security of VB Project

I have a macro that I want to write code for various commandbuttons that are
created via macro. I manually put a check in the "Trust access to Visual
Basic Project" spot under ToolsMacroSecurity. But it keeps unchecking
itself.

Is there a way for me to check the status of "Trust access to Visual Basic
Project" and if there is not a checkmark, place one in there via a macro?

Thanks,
Les