Userforms do not respond properly to VBA code on updated Office 365 but do on older Office 365

Question

Thoughts, solutions?   Been creating and using userforms with vba code in Excel 2016 for almost a year.  All has worked well until today (10/19/2016).  The VBA code is suppose to make command buttons, labels and/or textboxes visible or not visible as other actions happen.  Today some of the command buttons, labels and/or textboxes become visible while others do not; and vise versa.  This condition is happening with old code, new code, new userforms; doesn't seem to matter.  Even tried older file versions with the same code and the results were the same.  Next I tried the same files on another computer with an older update number of Office 365 and the problem does not occur.

Problem computer: Office 365 version: MSO 16.0.7329.1017  Current Channel 1609 (Build 7369.2038)

Computer without the problem: Office 365 version: MSO 16.0.7030.1021 Current Channel 16.0.7070.2033

Virus scan showed clean on both laptops.

Critical to have an operating file so I don't want to let the older versioned computer update at this time.

Seems like everything points to the newer updated Office 365 version; however, I don't now how to resolve.

Thanks in advance.

Answer 1

Kyle, could it be related to the recent UserForm reports on this TechNet thread? There was a problem with frames that lingered on, but the fix for this is now available. Could you try updating to Version 1611 and tell me if this solves the problem? If not, I'm happy to run your file by the engineering team.

Answer 2

Hi everyone,

The Office team is aware of the recent issues described in this thread, including BackStyle not respecting transparency, and they are working on getting the fixes out soon. I'll be back when the release timeline firms up.

Anneliese

Answer 3

We have the same problem and I can confirm that it is an office 365 issue.

Our solution has been so copy an old version of the "root" (C:\Program Files (x86)\Microsoft Office\root) folder to the computers that have this problem. The userform is crucial to our business so we really don't have any other options. It has to work all the time every day.

I hope this information helps.

Answer 4

Re: another untested update for excel or windows10 or both

See this...  https://social.technet.microsoft.com/Forums/en-US/9796fd67-e65c-4086-a2db-b990a17077b8/office-vba-controls-transparacy-not-working-since-october-2016-office-update?forum=Office2016ITPro

 (i use xl2010 with no updates allowed)

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 5

I have the same issue with excel 2016 standalone versions on two work pc's. No issues on 3 other machines. All have same updates over the weekend, all win7 machines. For some mysterious reason two of the machines have form control issues. Some of the properties work for the form controls such as text align but backstyle transparent will not work. Also some forms open and command buttons work but other forms command buttons disappear when I click on them.

Have checked permissions etc. Followed all the suggestions in this post about the 2014 update that crashed activeX and form controls. https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2015/12/22/form-controls-stop-working-after-december-2014-updates/

None of the suggestions worked. 

It's weird. Its like some of the properties work fine but others such as visibility and backstyle do not. I have already spent a day trying to fix with no luck. 

If someone cannot come up with a fix I guess the only solution will be a fresh install of win7 and reinstall excel.