Excel 2010 to Microsoft Excel 365

[ststern45]

Hello everyone,

I just upgraded to Microsoft Excel 365. I still use Excel 2010.
Couple issues to see if there is a solution.
1>My Excel file .xlsm has modules (VBA), In Excel 2010 when I select view code, the window opens and I only see 1 window. When using Excel 365 all the code windows appear. Is there a way only 1 window will appear?

2>My worksheet contains a Toolbar. When I click the Toolbar the Toolbar disappears but reappears when the code completes. I did not have this issue in Excel 2010

3>I have 2 Excel files open. When I run a macro how do I keep the screen from blinking?

Thanks

 

[rlv01]

1. I think it may mainly be configuring your 365 editing environment. I have 2010 on one PC and 365 on another and I've made the 365 windows look more or less the same as the 2010 PC.
2. I have not seen that.
3. If Application.ScreenUpdating = False does not work, then you probably cannot. There is a certain type of screen flicker that is beyond the ability of VBA to control