Excel 2010 to Microsoft Excel 365

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
814
Office Version
  1. 2010
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

rlv01

Well-known Member
Joined
May 16, 2017
Messages
771
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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,331
Messages
5,624,063
Members
416,010
Latest member
NJT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top