Prevent "Enable macros" prompt every time a macro button is presse

  • Thread starter Thread starter jenant
  • Start date Start date
J

jenant

I created an Add-in that adds some buttons to my toolbar using the excellent
"Create an ADD-IN with TOOLBARS that run macros" article
(http://www.pptfaq.com/FAQ00031.htm). It works well and I've started to
share it with colleagues.

The problem is that we get an "Enable macros" prompt every time we press a
button. It's no problem at all to hit "Enable macros" once when you open a
file... but every time a button is pressed? Not so good.

Is there any way to set some sort of master macro enabler? We cannot change
our security settings, as this is a corporate envirnoment and we do need to
see when macros are being used--it's just that we want to do it once only.

Thank you!
 
Ah! You're absolutely right, we didn't install it correctly. We had already
loaded the toolbar using the ppt macro and the ppa didn't overwrite it. I
unloaded the Add-in, deleted the toolbar, and reloaded the Add-in--works like
a charm!

It is just amazing what VB can do.

Thank you!
 

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

Back
Top