Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: automatically enable macros on file open

  1. #1
    Join Date
    22nd August 2003
    Posts
    38

    automatically enable macros on file open

    Okay, so I'm working on the publishing and distribution of my huge automation project. For a number of reasons I have chosen to create a workbook with buttons that trigger the various automations. It also includes tabs with instructions for the various processes and such. I am not particularly concerned about users altering my code. And they got very scared when I used the phrase "add-in". This is the best way to go.

    Now I have one little idiot-proof I'd like to code in. When a user opens this particular file I'd like to prevent the "enable/disable macros" message from appearing at all. Instead I'd like to simply force the macros to be enabled and not let the user have any say in the matter.

    I'm sure this is easy to do, but need someone to point me in the right direction.

    Thanks,
    Kelly.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678
    Bad news i'm afraid kelly.

    The enable macros issue is part of Excel's inbuilt security & cannot be bypassed. Individual installations of Excel can alter the settings so that macros are automatically accepted - this ca be done by selecting Tools|Macros|security & setting the option from High or Medium to Low - but....it needs to be done for every potential user.... i.e. not a great solution...


    Sorry for the bad news,

    Will
    Last edited by Dave Hawley; July 9th, 2010 at 09:53.
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  3. #3
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678
    Kelly...

    This was the "granddaddy" of all posts on this subject of Excel Security...

    http://www.ozgrid.com/forum/viewthread.php?tid=223

    Even if there were a way to bypass Excel Security ( :wink1: ) you will not find it here. Apologies once more.

    Will
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  4. #4
    Join Date
    22nd August 2003
    Posts
    38
    Ah well, I will just have to trust my users (ack!) to know that when opening a file specifically created to hold macros they likely should click to enable them when they open the file. Sigh. The team as it stands is plenty competent enough to do this, but I'm envisioning future staff not quite as comfortable with Excel. Unlikely in the tax department of a large mutual fund company, but possible nonetheless.

    Thanks,
    Kelly.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678
    Unlikely in the tax department of a large mutual fund company, but possible nonetheless.
    :biggrin: :biggrin:

    You can set the workbook to just display on sheet saying "Macro's Must Be Enabled" if macros are not enabled - and instruct the user to close & re-open with macros enabled... - this is a somewhat clunky but effective workaround.....

    Basically all sheets remain veryhidden if macros aren't enabled.... there is a macro in the worksheet_open event that unhides all sheets & hides the warning message sheet

    Might be worth a try... you can find this procedure written by Dave Hawley on the main Ozgrid site - and it's free

    http://www.ozgrid.com/FreeDownloads/EnableMacros.zip

    Will
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Enable Macros Prompt When No Macros Present
    By eoaevan in forum EXCEL HELP
    Replies: 8
    Last Post: December 19th, 2007, 09:28
  2. Replies: 1
    Last Post: November 20th, 2007, 22:22
  3. Enable Macros Upon Opening a File With VBA Code
    By doowlehc in forum EXCEL HELP
    Replies: 3
    Last Post: November 14th, 2005, 08:44
  4. Enable Macros Automatically
    By h in forum EXCEL HELP
    Replies: 1
    Last Post: August 13th, 2004, 21:13
  5. open and process .csv file automatically
    By DNAgirl in forum EXCEL HELP
    Replies: 5
    Last Post: May 22nd, 2003, 22:49

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
  •  
porno