• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changes in Office 365 - Excel 2016 vs previous versions

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
 
We also spotted that the right mouse click although there - just stops working.

Plus a picture we added to a user form - does not show a 'Click Event' procedure but a "Private Sub Image1_BeforeDragOver" when you CLICK on it!
 
Image_Click() isn't in object's member list. However you can still use it.

See image below for member list for Image object.
upload_2017-5-8_11-46-42.png
 
Back
Top