+ Reply to Thread
Results 1 to 3 of 3

about security settings for macros

  1. #1
    Registered User
    Join Date
    12-28-2009
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2003
    Posts
    31

    about security settings for macros

    Hi guys ,
    Im a little unfamiliar with VBA Excel , hope you can take a look at this:


    Whenever I try to run a macro with VBA Excel I get this error :
    The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros .

    I allready changed my Securtiy settings for macros to the lowest level and selected trust all for trusted sources , but I still cant run macros.


    btw Im using Microsoft Excell 2003
    much thanks.
    Last edited by masterinex; 12-28-2009 at 09:58 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: about security settings for macros

    Hi masterinex,

    welcome to the forum

    set macro security to medium, (not low, you don't want to open up your system to all kinds of damage), then close Excel completely and open the file with the macro again. You should now be prompted whether you want to allow the macros to run.

    hth

  3. #3
    Registered User
    Join Date
    12-28-2009
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: about security settings for macros

    Yes it worked !

    thanks teylyn

+ 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