+ Reply to Thread
Results 1 to 3 of 3

Excel 2007: prompt to enable macros option no longer exisits

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel 2007: prompt to enable macros option no longer exisits

    Capture.PNG

    I have written a macro and I want to use it but I can only seem to do this by selecting enable all macros which seems risky (see attached). The option to prompt before enabling macros doesn't seem to be there anymore which is strange as I had this before I re-installed windows and office... Can anyone help?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel 2007: prompt to enable macros option no longer exisits

    if you choose disable with notification, you should get the message bar appearing (you will only see the old style 'enable macros' dialog if you have the VB Editor open)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    06-06-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel 2007: prompt to enable macros option no longer exisits

    Thanks Joseph, that did it. Much appreciated!

+ 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