+ Reply to Thread
Results 1 to 6 of 6

Macros are blocked from running

  1. #1
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Macros are blocked from running

    When I send a workbook with macros to some of my users, they either can not open the workbook due to there being macros or they have to enable them each time the workbook is opened.

    I know there is a way to correct this, but I don't know how to look this up in help so I am coming to my trusted friends on Excel Forum.

    I would also like to know what this is called as I slightly remember that there is a name for this.
    Last edited by Launchnet; 11-19-2009 at 03:04 PM.
    Thanks for helping . . .
    Matt @ Launchnet

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Macros are blocked from running

    XL2007: http://office.microsoft.com/en-us/he...310711033.aspx

    XL2003: http://office.microsoft.com/en-us/ex...195791033.aspx

    Generally speaking - running Macros security on Low is ill advised and were your IT dept to find out they'd probably hang you out of the window by your ankles...
    Last edited by DonkeyOte; 11-19-2009 at 02:14 PM. Reason: typo

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macros are blocked from running

    The big-boy way is to get a digital certificate from VeriSign.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Macros are blocked from running

    You mean you're not supposed to setup your 'My Documents', 'Desktop' and root folder as trusted folders, and open all macro-enabled files from there??

    (Note to people viewing this that don't know me: Don't do this.)

  5. #5
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: Macros are blocked from running

    SHG
    Thanks, this is what I need.

    DO YOU HAVE LINK ?

  6. #6
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: Macros are blocked from running

    Thanks - I found it. Will mark solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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