View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Programmatically check security of VB Project

Les, when you check the allow access box, do you exit by clicking OK or by
clicking the big red X? If you use the big red X, then you do not set the
check mark. You must click OK to exit after you put the check in the box.
It has to be manually changed back after that. I don't know of a way that it
would automatically uncheck itself. Mine has been checked for four years and
has not changed.

"WLMPilot" wrote:

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