+ Reply to Thread
Results 1 to 8 of 8

macros are enabled but not working in this excel file..

Hybrid View

  1. 08-27-2015, 01:52 PM #1
    prince bhatia
    prince bhatia is offline
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22

    macros are enabled but not working in this excel file..

    hi, all this is my first question in this forum,hope i would get some answers as my question is too small

    i have an excel file which is macro enabled but macros are not working for me....can anyone look into matter please....may be it will work for you but everytime i press the button i get the message...the macro may not be available in this workbook or disabled.Sheet is attached!

    help would be appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-27-2015, 02:41 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: macros are enabled but not working in this excel file..

    If you right click on each button and select Assign Macro, you will see that currently they refer to a non-existent Sheet4.

    You need to select a valid macro to be executed.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 08-27-2015, 10:23 PM #3
    prince bhatia
    prince bhatia is offline
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22

    Re: macros are enabled but not working in this excel file..

    Hi, may be i am asking more, but sir can you please help to activate it,actually it's my office work and very important file
    Reply With QuoteRegister To Reply
  4. 08-28-2015, 07:31 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: macros are enabled but not working in this excel file..

    See if the attached workbook works for you.

    Regards, TMS
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-28-2015, 07:52 AM #5
    prince bhatia
    prince bhatia is offline
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22

    Re: macros are enabled but not working in this excel file..

    Hi, the option for slicer is not visible it says it can be used for at least more excel 2010 and i am using 2013,,,,,,these problems i am facing..can it be fixed?
    Reply With QuoteRegister To Reply
  6. 08-28-2015, 08:03 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: macros are enabled but not working in this excel file..

    I think you will need to start a new thread for that question. I am not familiar with slicers.

    Regards, TMS
    Reply With QuoteRegister To Reply
  7. 08-28-2015, 08:14 AM #7
    prince bhatia
    prince bhatia is offline
    Registered User
    Join Date
    07-29-2015
    Location
    new delhi
    MS-Off Ver
    2007
    Posts
    22

    Re: macros are enabled but not working in this excel file..

    hi,,,,now worries i got the solution ,..what i did i deleted old slicers and and updated them again ..and it's working fine now same..superb...thank you sir..
    Reply With QuoteRegister To Reply
  8. 08-28-2015, 08:54 AM #8
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: macros are enabled but not working in this excel file..

    Glad you've managed to get it working. And thanks for the update; it's useful to be aware of workarounds like this.

    Regards, TMS
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel file often opens with Macros disabled though Macros & Active X controls are enabled
    By Balachan56 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  2. Excel crashes when macros are enabled
    By Phillip.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2013, 12:09 PM
  3. File size with macros enabled is huge
    By somedudeonline in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2013, 06:52 PM
  4. How do I Disable Macros on a File where Macros were Previously Enabled?
    By Alves76 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2013, 10:26 AM
  5. Kindly treat urgent ... Macros in file to be kept enabled even after mailing the file
    By siya in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2011, 04:03 AM
  6. Close Excel if macros not enabled
    By philbennison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2007, 10:29 AM
  7. Programmatically finding out if Excel macros are enabled.
    By Zhwgnon Flrq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1