[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 627
  • Last Modified:

Run PowerPoint 2007 macros from the Quick Access toolbar

Hello,
I have made a PowerPoint 2007 template containing macros. I want to be able to distribute this template to other users and enable them to run these macros in all new presentation based on this particular template. Therefore I open the potm file and add buttons to the Quick Access toolbar (I make them available to the template file, not "All presentation").
When I click the buttons in the potm file, they work fine. If I create a new presentation based on the template, the buttons shows up, but when I click them, I get the message that "the macro is not found or disabled due to security settings". When I go to the Developers tab and select Macros, and select the macro in question and click "run", the macro runs perfectly. So obviously it is the button on the Quick Access toolbar that does not work.
Can anybody help me? Thank you very much in advance
0
WordSpecialisten
Asked:
WordSpecialisten
  • 3
  • 2
1 Solution
 
hnasrCommented:
If you can reproduce the issue with a one slide presentation, attach here to check, with instructions to replicate the issue.
0
 
WordSpecialistenAuthor Commented:
Hi,
The potm file extension is not in the list of accepted extensions, so I can't upload the file.
But it is really easy to reproduce the problem:
1) Create a new blank presentation
2) Save the file as a potm file (I call it "TestTemplate.potm")
3) Go the the Visual Basic editor, insert a module (I call it "modMacros")
4) Create a procedure: "sub Test". Here I just a simple messagebox, saying "You clicked the button"
5) Then I add the macro to the Quick Access toolbar, making it available to "TestTemplate.potm" (not "All Presentations")
6) I click the button, and the msg box appears
7) I close the template, and then I create a new blank presentation based on the template
8) I click the button on the Quick Acces toolbar - and then received the error message as posted earlier
0
 
hnasrCommented:
The macro name is saved with the Presentation name
Keep the original file open, the new presentation works.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
WordSpecialistenAuthor Commented:
Hi,
It is not a solution to keep the original file open. I can't tell my users to keep an original template open, while working with presentations based on it. The template will get corrupted, and multiple user can't open the same template at the same time over a network.
I guess the solution then must be to create an add-in instead, so that the macro is permanently available via a tab on the Ribbon. I just hoped to avoid this.
Thank you very much for your attempt to help me.
0
 
JSRWilsonCommented:
The answer is to create an AddIn. It's the only reliable way in PowerPoint.
0
 
WordSpecialistenAuthor Commented:
Thank you for your comment. I have already tried the add-in solution, and it works. It is just annoying that I have a permanent command on the Ribbon that is only minded for one particular presentation. And what is the whole point of having the option to make macro-enabled PowerPoint templates, if you can't use them. But thank you for your statement, because now I know that I can't do, what I want to :-).
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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