Consulting

Results 1 to 5 of 5

Thread: PowerPoint Macro in Personal File

  1. #1
    VBAX Regular
    Joined
    Oct 2015
    Posts
    21
    Location

    PowerPoint Macro in Personal File

    Hello,

    I know that Excel has a way to create macros and save them to a personal spreadsheet that can be opened in the background to be used in any instance of excel. Is this possible in PowerPoint and other Microsoft program or is that only available for Excel and Word (if I recall has its own version)?


    Thank you,

  2. #2
    VBAX Regular
    Joined
    Oct 2015
    Posts
    21
    Location
    Hello,

    So I have found a link that would help me create an add-in (https://answers.microsoft.com/en-us/...a-a01f9cceb3cd).
    However, once I followed these steps and attempted to run a macro from the add-in file I get an error message (The macro cannot be found or has been disabled because of your security settings.). I went into the trust settings and within the macro settings I have "enabled all macros" and selected "Trust access to the VBA project object model", but I am still getting the above error message.

    Is it something that I missed or would it be something within the company's security settings that I would need to inquire about?


    Thank you

  3. #3
    VBAX Regular
    Joined
    Oct 2015
    Posts
    21
    Location
    never mind ... I fixed my mistake. I had to change the file path name in the code to where the file is saved in my computer. Duh!! LOL!!!

  4. #4
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Glad you made it work but it really is not the way to do it (especially if you aim to write more)

    There's a page on our site to help you create a ribbon entry
    http://www.pptalchemy.co.uk/custom_UI.html

    Right at the bottom you can also download a free "Add In Kit"
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  5. #5
    VBAX Regular
    Joined
    Oct 2015
    Posts
    21
    Location
    John,
    I am on the office VDI session and I cannot downloadanything to the computer, which is why I did it this way. However, I am havingan issue though. My saved addin file keeps getting removed when I restart myVDI session. Would you happen to know why this is happening?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •