Peter Bradley
New Member
We've recently moved to O365 and are experiencing a few differences which are hard to explain.
1) The macros we have to add new right mouse click options seems different. I think this has something to do with the SUI that XL now creates. As if you open book A with the macros in it to add the menu options all books opened after that had the same right mouse menu. If you open Book B first and book A, book B displays only the normal menu - unaltered.
2) After putting stop marks in the VBA code it does not necessarily stop the code on the workbook it is on, but rather the workbook that had the macro in it. This is a pain when trying to debug code.
Has anyone else spotted or experienced these or other issues moving from 2010/13 to 2016 versions?
Peter
1) The macros we have to add new right mouse click options seems different. I think this has something to do with the SUI that XL now creates. As if you open book A with the macros in it to add the menu options all books opened after that had the same right mouse menu. If you open Book B first and book A, book B displays only the normal menu - unaltered.
2) After putting stop marks in the VBA code it does not necessarily stop the code on the workbook it is on, but rather the workbook that had the macro in it. This is a pain when trying to debug code.
Has anyone else spotted or experienced these or other issues moving from 2010/13 to 2016 versions?
Peter