Excel 365 - Macros Not working within the Ribbon (Moved,Renamed,Deleted)

[dave_w1967]

Huge Hello to all the Guru's

I have upgraded from Excel 2007/Excel 2010 to Office 365 (Monthly Subscription Version), previously all the macros/VBA Coding that I use worked nearly all of the time, since upgrading to the newer version of excel all my macro's/VBA coding works perfectly. So you may ask whats the problem? well I decided to take advantage of the 'Ribbon' and change from macro buttons to having all my macro's in the ribbon and it worked perfectly and looked quite professional, I do a 'SAVE AS' with this file each week the only items that get changed is the daily dates and work orders nothing else is changed. So coming up to a meeting I copied my file to a thumb-drive which I always do, went into the meeting room set everything up, opened up my newly designed excel file, clicked on a macro in the ribbon and to my astonishment I get the dreaded error "Sorry, we couldn't find 'C:\Maintenance\weekly schedule\..................... Is It possible it was moved, renamed or deleted? and of course the macros/VBA coding did not work. I spent the weekend researching about this error and tried various solutions to none worked. I tried different ways of saving to which nothing worked, Character length is a total of 114 characters so I don't think that is a problem with saving. My only alternative was to go back to my original macro buttons to be able to 'SAVE AS' and work with the excel file as normal.

Question to all is there some sort of fix for this? Am I doing something wrong i.e. saving it as a "SAVE AS' instead of something else? I tried exporting and importing the customization file to which the same error popped up, I have emailed Microsoft and still waiting for a reply! so now I'm at a loss, maybe there is no fix and it is one of Microsoft's many problems! If there is a solution I would be entirely grateful.

Again thank you for your valuable time, and please excuse my long winded story!

Best Regards
Dave.

[6StringJazzer]

Are you saying you developed the file on one machine, then tried to use that file on a different machine?

What file contains your macros? If they are in a file that is not on the meeting room machine, then of course Excel can't find them. Actually I'm surprised you can even see the ribbon customizations. I think we need a little more information about how you are managing your macros, and what you want to do.

I put all my Ribbon macros in PERSONAL.xlsb but then they aren't available on any other machine. I have some files that have macros specific to that file, and so they are stored in that file, but I still can't see ribbon customizations on a different machine.

[romperstomper]

If you create your macro buttons through the customize ribbon dialog, the full path to the macro file is hardcoded to the buttons. So if you change the name or location, the buttons won't work. If the macros are specific to a particular file, you should really look at using the CustomUI editor instead: http://www.rondebruin.nl/win/section2.htm

[dave_w1967]

Thanks for your reply, it has certainly cleared a lot of things up. I was looking at Custom UI but was not sure if this would be the way to go or if I would have the same problem.

Again Thanks for all your help.