Avatar of Joe Howard
Joe Howard
Flag for United States of America asked on

VBE not showing existing code

After years of programming in most of the Microsoft Office suite applications, this morning I was hit by an anomaly.

The VBE will not show the code, any existing code. I can write code but once saved and reopened it all vanishes. This happens with all Office files (Word, Excel, Access etc.). The modules appear the the VBE tree, but when opening one, the VBE remains blank as if a module was never opened. The code however does exist as it runs as expected and when a module is exported the bas file contains all the code. Yet for some reason the code is not shown in the VBE.

On other computers everything works, so the problem is not with the files but rather with the computer\ Office installation. Rebooted Windows, re-installed Office, yet problem persists.

Searching online it seems that a handful of users experienced the same issue but I couldn't find a solution.

Ideas are welcome and your help is greatly appreciated.


EDIT: If I search for a function only that function will be shown.
ProgrammingMicrosoft OfficeMicrosoft AccessMicrosoft ExcelMicrosoft Word

Avatar of undefined
Last Comment
Joe Howard

8/22/2022 - Mon
Zaheer Iqbal

Have you had any updates on the machine ?
What happens if you run VB application in compatible mode to use a lower version of Windows ?
sarabande

you might get this if text and background color are equal. you should see that by using 'End' key of your key board on some lines. if so, check if you were able to change either background color or text color.

Sara
Joe Howard

ASKER
Thanks sarabande, but this doesn't help Option Explicit does show on the top then I can go down 2 lines but that's it. Changed both the foreground and the background, same problem.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Gustav Brock

I would run a reinstall to clean up this unusual state of the installation.
Joe Howard

ASKER
Thanks Gustav, but as mentioned in the question, uninstalling and reinstalling didn't help. I uninstalled using Microsoft's Removal Tool.
Zaheer Iqbal

have you tried compatibility mode ?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Joe Howard

ASKER
Thank you Zaheer, no new updates were installed that I know of, everything worked fine last night.
I'm not sure where you're going with the compatibility issue, I'm dealing with Microsoft Office.
Joe Howard

ASKER
Zaheer what should I run in compatibility mode?
Zaheer Iqbal

VBE application on the shortcut change the compatibility mode options to say Windows XP
Your help has saved me hundreds of hours of internet surfing.
fblack61
Joe Howard

ASKER
Shortcut to VBE?! What is that?
mbizup

Is this happening with ALL files containing VBA, or is it limited to files in specific folders, etc?
mbizup

Also, what versions of Office/Windows are you running on the problematic computer?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Joe Howard

ASKER
mbizup It happens with all files that contain VBA.
The computer in question is running Windows 10 64 bit and Office 2016 Pro Plus 32 bit.
mbizup

Have you verified that none of the other windows (such as the Immediate or Watch windows) were inadvertently resized in a way that obscures the code window?

Can you post a screen shot of the full editor window?
Joe Howard

ASKER
VBE ScreenShot
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Joe Howard

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mbizup

Glad you've got it resolved - what an obscure issue!
Joe Howard

ASKER
Thanks guys :)