Basic macro stuff

  • Thread starter WhyIsEverythingSoConfusing
  • Start date
W

WhyIsEverythingSoConfusing

I am VERY new to macros and VBA. So, I'm trying to get something simple
before I try to tackle my real, larger problem (I'll save this for later).

Anyway, I created a simple, two line macro to create a MsgBox with the name
of a resource. I added it to a specific project and it worked fine.

Then Project crashed. I opened the project again, and now I'm being told
that I can't run my macro because they are disabled for this project.

When did that happen and how can I again enable macros (at least those that
I write)?
 
G

Gilgamesh

WhyIsEverythingSoConfusing said:
I am VERY new to macros and VBA. So, I'm trying to get something simple
before I try to tackle my real, larger problem (I'll save this for later).

Anyway, I created a simple, two line macro to create a MsgBox with the
name
of a resource. I added it to a specific project and it worked fine.

Then Project crashed. I opened the project again, and now I'm being told
that I can't run my macro because they are disabled for this project.

When did that happen and how can I again enable macros (at least those
that
I write)?

Your macro security level is set to high.
When you go to Tools->Macro, select Security and change it to medium.

Alternatively you can look at getting a digital certificate to sign your VBA
code so you can leave the security level at high.
If you are the only one using the macros then you can use the selfcert tool
to create one, other certificates need to be created by an appropriate
authority and have a cost.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top