+ Reply to Thread
Results 1 to 2 of 2

Macro button not working but works when in module

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Macro button not working but works when in module

    I have a macro added to my ribbon and all it does is open a template. It isn't working but if I open the code and run it then it works fine. I've deleted the macro and added back it to the ribbon. My security settings are fine. Any ideas?



    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Macro button not working but works when in module

    Apparently it is because the name of the macro and module were the same that broke it. wow. So answer for any future googlers: DO NOT name the Module the same name as a Macro

+ 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. [SOLVED] Macro Speed difference by activating from button vs module.
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2017, 05:25 AM
  2. macro works in sheet but not in the module
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2016, 06:50 AM
  3. Macro works but not as a button
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2016, 02:25 PM
  4. [SOLVED] Call a macro within a button from a module
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2015, 02:29 PM
  5. Macro button works on my pc, no-one else's
    By ssu95bm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2015, 01:47 PM
  6. [SOLVED] Toggle button works on sheet but not when moved to module.
    By mandora in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2012, 01:45 PM
  7. Assigning a module to a button macro
    By DMB in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 08:40 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