Share Excel VB module used in ribbon macro with home laptop and work PC.
I recently upgraded from Excel 2002 to Office 365 as 2002 has crashed and I can't find the disks. I was surprised to find my workbooks work well with the new Excel. I am currently challenged with creating a ribbon UI for my macros. I have many VB files stored in the file RMEJMOD.xls. The file is currently stored in a Dropbox folder. The path to this folder is different in the home W7 laptop than the W10 PC at work. The macros used from this file called from all buttons I created in my workbooks work seamlessly but not in the custom ribbon I created. The path appears when you hover the mouse over the macro name in Customize Ribbon. It appears that the ribbon calls carry the full path to the macro and therefore will not execute when I import the ribbon UI from the other machine even when updating the link location. When the macro is selected I get the popup "Sorry, Excel can't open two workbooks with the same name at the same time." I could create a ribbon for each machine but I hope there is a better way. I really need a solution for this as I use at least 2 dozen macros in my workbooks every day. Any help will be greatly appreciated.
Excel's Ribbon irregularly dissapears/greys out!?
Can anyone help me out with this strange error? More and more colleagues are having the same issue where when they open an excel it works perfectly fine, they have the ribbon and menu above. But when they open another file the complete header greys out, there's no menu or ribbon. See attached screenshot of a file to the left which works perfectly fine, and the other file to the right missing the header. I tried to reinstall office, but the same problem occured. I hope anyone can help me with this! Thanks in advance, WesselExcel Online Ribbon not visible on SP2016 xlsx file
We have a Sharepoint 2016 environment. Something strange happens when we open a XSLX file in Excel Online: the ribbon is not showing. I have tested this in Chrome and IE11. Also this only happens on XSLX files. An older XLS file opens Online and shows the ribbon. Docx files also open without issues. Any help would be appreciated.
