PDA

View Full Version : PowerPoint Macro in Personal File



MHamid
02-05-2018, 09:49 AM
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,

MHamid
02-05-2018, 11:17 AM
Hello,

So I have found a link that would help me create an add-in (https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_other-mso_2010/how-do-you-save-macro-to-personal-module-in-pp/4b964ca5-9ef9-45bc-aa2a-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

MHamid
02-05-2018, 11:56 AM
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!!!

John Wilson
02-06-2018, 10:12 AM
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"

MHamid
03-06-2018, 02:28 PM
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?