+ Reply to Thread
Results 1 to 5 of 5

Macro Error Message

  1. #1
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Macro Error Message

    Hello,

    I am getting this macro error message when I use the arrows in the bottom to advance the months or for that matter even to go to a prior month. I tried to edit the macro but not able to see the actual recorded macro. Could someone please help?

    Thanks

  2. #2
    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
    44,319

    Re: Macro Error Message

    It is a .xlsx file. There won't be any macros in it. Hence when you click on something that expects to use code, it gives you the error message to say the macro isn't present.
    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


  3. #3
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: Macro Error Message

    Thank you. It used to have a macro. Is there a way to record a macro or any workaround this so that I can use this workbook?

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Macro Error Message

    Good afternoon Philipsfn

    Record your macro and then use Save As. You will then be able to save your file as a .xlsm file, which will keep the macro. The next time you open the file, make sure to open the .xlsm version and you will be able to use the macro.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  5. #5
    Forum Contributor
    Join Date
    07-14-2014
    Location
    New City, NY
    MS-Off Ver
    2016
    Posts
    181

    Re: Macro Error Message

    Thank you. I was able to revive this file again. Thanks for your time.

+ 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. Replies: 5
    Last Post: 12-08-2016, 06:43 PM
  2. [SOLVED] Error message when trying to record a macro - No Personal Macro Workbook
    By KimC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2014, 06:56 PM
  3. [SOLVED] Error in my Message box Macro
    By Sjoerdvdbosch in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2012, 08:32 AM
  4. Macro Error Message
    By MrMe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2006, 06:39 AM
  5. Macro error message
    By Mary Thomas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2006, 12:30 PM
  6. Macro Error message
    By Karen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2006, 01:35 PM
  7. Macro Error message
    By D Huber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 10:40 AM

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