• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

Excel, Visual Basic and security problem.


Hello Group,

In part of my code I'm using a procedure to detect number and list of existing macros in an active workbook. That works fine however, I'm having a problem when user has not checked the  "Trust access to Visual Basic Project" in 2nd tab of security tab (Tools > Macros > Security).

Is there any way that I can check it programmatically?

Regards,
ak
0
akohan
Asked:
akohan
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
No, otherwise what would be the point of having a security mechanism?

I suggest showing a dialog to the user telling them that, in order to use your tool, they need to set that option on.

Kevin
0
 
akohanAuthor Commented:


Yes. you are rignt.
Thanks that's what I did.

Regards,
ak

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now