+ Reply to Thread
Results 1 to 3 of 3

Excel 2013 - Macros on Ribbon

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    260

    Excel 2013 - Macros on Ribbon

    I've added a custom tab to the ribbon (Excel 2013) and have a group called MyFunctions that calls some macros I wrote. The problem I've found is that if I delete/move the original Excel file that I wrote the custom functions in, Excel can't find them. Is this normal? I would have thought if you attach a macro to the Ribbon then it would store the code in the standard Excel template (start-up file) rather than looking at the spreadsheet I originally wrote the macro in.

    In fact it OPENS the file with the macro in it, which is not what I want at all!

    What do people do to get around this?

    Cheers
    -Rob
    Last edited by TheRobsterUK; 09-15-2014 at 10:10 AM.

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Excel 2013 - Macros on Ribbon

    Your macros still exist in VBE editor if you delete or move the excel file ?
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  3. #3
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    260

    Re: Excel 2013 - Macros on Ribbon

    If I delete/move the file and then try to run the macros on the custom Ribbon then Excel throws up an error saying it can't file the file. :-/

+ 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. add in buttons in excel 2013 on the ribbon
    By oeldere in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 05:30 PM
  2. Hide & unhide ribbon of excel 2013 using shortcut key
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2014, 09:45 AM
  3. Excel 2013 Inquire feature Ribbon disappear
    By Billy Jones in forum Office 365
    Replies: 2
    Last Post: 09-07-2013, 07:43 AM
  4. Please help with 2013 ribbon customization
    By thetexan in forum Excel General
    Replies: 1
    Last Post: 07-06-2013, 12:21 PM
  5. Excel 2007 : Excel Macros and Ribbon
    By DougQval in forum Excel General
    Replies: 1
    Last Post: 10-08-2009, 02:48 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