Forum Discussion

tomrdillon1944's avatar
tomrdillon1944
Copper Contributor
May 18, 2020

PERSONAL.XLB NOT WORKING ON 365

With excel 2010 and earlier versions I have created a custom toolbar that uses excel native commands and many many macros stored in personal.xlb. In the past when I bought a new computer I could expe...
Macros and VBA
amit_bhola's avatar
amit_bhola
Iron Contributor
May 18, 2020

tomrdillon1944 , not sure if it would work but you could give it a try. I may have partial understanding of your issue given that i am not a 365 user and also am not an expert on working with ribbon customizations :-

1. Export the customized ribbon to a file.

2. Open the exported file with notepad or other text editor. It should show the xml data of the customizations with 'onAction' property for each button, something like onAction="C:\path\personal.xlb!Modulename.Macroname" .

3. Check that the "path" part of this property value is really the actual path where you have kept the .xlb file (START folder) or not. If not, then replace the incorrect path with the correct path. Do this for all button propertis in the file.

4. Save the ribbon customization file and import it.

  • tomrdillon1944's avatar
    tomrdillon1944
    Copper Contributor
    May 18, 2020

    amit_bhola  Thanks. But I don't have a problem with the customized ribbon. It all looks good and each item connected to a macro show the path of the macro, etc.  But when clicked on nothing happens.

Resources