+ Reply to Thread
Results 1 to 3 of 3

PowerPoint Macro Disabled

  1. #1
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    49

    PowerPoint Macro Disabled

    Hi All, I've created a macro which automatically exports my PowerPoint as a PDF with a certain name but to use it at work, I have to import the module every time I want to use the macro which makes it pretty much pointless. I'm assuming it's something to do with blocked settings given that if I save the PP as macro-enabled, I'm unable to even run it and so is there any way for me to run such a macro from my personal library or something? Just so that if I add it to the toolbar, I'll be able to to use it on all my PPs going forward.

    I'll greatly appreciate any help with this.

    Many thanks!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,145

    Re: PowerPoint Macro Disabled

    In Excel the PERSONAL.xlsb file is always loaded, and in Word Normal.dotm is always loaded. Unlike Excel and Word, PowerPoint does not have a standard macro library/file that is always available, and doesn't have a startup folder where files are automatically loaded.

    One way to do this is to take your macro-enabled file and create an add-in, and then install the add-in. (This works only for your machine; if you are trying to distribute files to other users than depend on macros it gets more complicated.)

    I'm not following what you are saying about blocked settings. Some company filters won't let you download email attachments with macros, but I am not aware of blocking them from running at all. Maybe you need to check the security setting in PowerPoint to allow macros.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: PowerPoint Macro Disabled

    ... if I save the PP as macro-enabled, I'm unable to even run it...
    I'd check with your IT. In certain cases, company policy will disable use of macro unless supported by digital signature (through GPO or other means).

    If that's the case, you'll need to look in your Office installation folder for "SELFCERT.EXE". Exact location will depend on your version etc.

    Run it. Follow screen to create certificate. This will allow you to use Tools -> Digital Signature to assign certificate in VBE and will allow your code to run after save.

    But, I can't be sure if this is the case. As I never had to use this myself. Only helped others to implement this.
    Last edited by CK76; 06-25-2020 at 04:28 PM. Reason: Added part about GPO
    Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] The macro in this projects are disabled How to fix it
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2016, 06:24 AM
  2. [SOLVED] macro disabled
    By var in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2012, 02:21 AM
  3. Excel 2007 : Macro disabled with sharing
    By rasmus1166 in forum Excel General
    Replies: 1
    Last Post: 11-04-2011, 09:22 AM
  4. macro disabled
    By jw01 in forum Excel General
    Replies: 4
    Last Post: 12-01-2010, 12:52 PM
  5. Macro Disabled.
    By 1heng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2007, 08:30 AM
  6. Macro Disabled Error
    By vamosj in forum Excel General
    Replies: 1
    Last Post: 02-27-2007, 07:12 AM
  7. if macro is made disabled.??
    By roshinpp_77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2006, 02:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1