+ Reply to Thread
Results 1 to 13 of 13

Ribbon Edit the existing file

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Question Ribbon Edit the existing file

    Hi
    I need to know how do I edit a file that was saved as myFile.xlm
    I downloaded the editor of Andy ribbons pope
    But I can not edit an existing file, that is, all I have in the spreadsheet to not have to do it again.
    Last edited by marreco; 07-13-2012 at 07:56 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,183

    Re: Ribbon Edit the existing file

    If I understand your question, did you look here for help?

    Excel 2007-2010 Ribbon and QAT pages
    HTH
    Regards, Jeff

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,038

    Re: Ribbon Edit the existing file

    Try -
    http://www.excelforum.com/excel-prog...-xlm-file.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi.
    Thanks to both! happens that I'm using a file (in my work Excel 2010), where it built my project. poerém now after all is done I try to disable two guides, I can only do this by generating another file. I need to do this in my project, if you do not have to do my project again.

    Thank you!!

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi.
    any suggestions?
    Thank you!

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Ribbon Edit the existing file

    maybe try explaining the problem again-I'm afraid I have no idea what you've tried or why you can't use the CustomUI editor to do it.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  7. #7
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi.
    What I need is to disable the tab 'Home' tab and 'develop' my ribbon.

    I can do it!

    However the file is saved as a new file with these tabs disabled.

    In my case I have a project already desennvolvido, where it has forms and routines.

    I would like to disable the tabs without having to do all my project again

  8. #8
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Ribbon Edit the existing file

    so why can't you just copy the customui.xml code from one workbook to the other using the CustomUI editor?

  9. #9
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi

    When trying to download and use the editor made ​​by Andy Pope.

    Does any 'reference' What's missing?
    I'm using windows XP and Excel 2007

    Is generating the following error ..
    Compile error in hidden module: FRibbonDesigner

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,174

    Re: Ribbon Edit the existing file

    Do you have all the libraries specified on the web page?
    Do you have addins enabled as specified on the web page?
    Have you tried the MS Security patch fix as specified on the web page?

    It's confusing as you say you have xl2007 and the xl2007 version of the editor but you are working in xl2010
    Cheers
    Andy
    www.andypope.info

  11. #11
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi Andy
    I have in my work the xl2010. in this case I have no problem
    The problem I am having is at home with xl2007.

    in fact what it is.

    I would like to know is if your editor, I can get a file where in it I have a project already developed after that edit the Developer tab.

    when I try to do this, I have to create a new file.

    More so I'll have to redo my whole project.
    Thank you!

  12. #12
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,174

    Re: Ribbon Edit the existing file

    If you have placed your ribbon xml in the xl2010 (CustomUI14) section of the file then you will not see it in xl2007.
    My editor will only allow you to view/edit the customui14 section if you are using xl2010.

    The customUI editor is not so fussy as it does not use Excel at all.

  13. #13
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,857

    Re: Ribbon Edit the existing file

    Hi Andy

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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