+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 macro error 100316

  1. #1
    Registered User
    Join Date
    09-05-2015
    Location
    hk
    MS-Off Ver
    2007
    Posts
    2

    Post Excel 2007 macro error 100316

    When I press a button with macro, it shows:

    Cannot run the macro 'item '. The macro may not be available in this workbook or all macros may be disabled.
    100316


    Sometimes ,it shows out that I can solve the problem by adding permission to macro, but it will bugged and the file will be closed.

    excel macros

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,657

    Re: Excel 2007 macro error 100316

    After adding permission, save the file.
    There is a big chance excel will not ask again.
    Best Regards,

    Kaper

+ 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. Excel 2007: A Macro created to run Solver returns error message
    By chrys_t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2014, 08:45 PM
  2. Vba error 400 in macro using excel 2007
    By PeterJohns in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 11:44 AM
  3. Macro from Excel 2007 now has error in 2010 - invalid command?
    By missyreiber in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2013, 10:18 AM
  4. Replies: 1
    Last Post: 03-08-2012, 05:14 PM
  5. Runtime error 1004 using macro in excel 2007
    By CrazyHorse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2011, 11:54 AM
  6. Excel 2007 pivot table/macro/Runtime error 1004
    By abalserv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2010, 06:36 AM
  7. Run-time Error 9 with Excel macro - Runs in 2003, Fails in 2007
    By jialant in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2008, 09:37 AM
  8. [SOLVED] Excel 2007 Beta 2 - Macro Run-time error '424' Object required
    By jcm21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2006, 02:20 PM

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