Windows 10: Can't open the immediate window in ACCESS VBA

Recently I have been unable to open the immediate window or locals window or watch window when working in Access 365. I'm not sure if this happened after the most recent Windows/Office365 updates, but it is very recent. Any help available?

Gordon

:)

 

Windows 10 Tweaks

Pressing “Windows+Pause Break” (it’s up there next to scroll lock) opens the “System” Window.

Windows 10: In the new version of Windows, Explorer has a section called Quick Access. This includes your frequent folders and recent files. Explorer defaults to opening this page when you open a new window. If you’d rather open the usual This PC, with links to your drives and library folders, follow these steps:

• Open a new Explorer window.
• Click View in the ribbon.
• Click Options.
• Under General, next to “Open File Explorer to:” choose “This PC.”
• Click OK

credit to Lifehacker.

 

VBA code

Ok, let's see if this helps:

https://docs.microsoft.com/en-us/visualstudio/v...

To enable or disable access to Visual Basic projects

Click the File tab.

Click Options.

Click Trust Center, and then click Trust Center Settings.

In the Trust Center, click Macro Settings.

Check or uncheck Trust access to the VBA project object model to enable or disable access to Visual Basic Projects.

Click OK.

See if you can open your code now.

- C

 

Excel 2016 workbook with VBA shuts down immediately after opening it

I built an Excel workbook (CPD.xlsb for reference). It has extensive VBA programming, including code that executes when the file is opened (Private Sub Workbook_Open() etc.).

The workbook has been deployed to nearly 70 users who have been running it for 8 months. In that time, it has run on some combination of Windows 7 or 10, 32-bit or 64-bit, and Office 2013 / 2016 (a.k.a. 365 ProPlus). Nearly all of the users are now on Win10/Excel2016, and it works on all of the OS/Office combinations, in 7 countries, on 4 continents . . .

. . . except for one guy. (There's always one, right?)

He has Win10/Excel2016 like most of us. He can run other VBA-laden Excel workbooks that I have built without a problem. But, whenever he opens this CPD.xlsb file, Excel immediately shuts down. When we restart it, Excel wants to start in Safe Mode, which we do. And, after a normal shutdown/restart, Excel opens fine. But, the CPD.xlsb will cause Excel to close every time we try to open it.

There are no pop-ups or warnings or explanations of what happened. Excel just quits.

There isn't even time to Ctrl+Break to interrupt the code before Excel shuts down.

With almost 70 other users not having any problems, I can't imagine it's a programming issue.

• I compared his Excel settings (File / Options) to mine, and they
  match exactly.
  
• I have given him a brand new copy of CPD.xlsb and put it in a
  different folder, and it crashes.
  
• I did the Quick Fix on MS Office 365 Pro Plus, and it still crashes.
  
• I did the Online Repair for MS Office 365 Pro Plus, and it still crashes.
  
• I sent him a different workbook with a simple Workbook_Open() routine
  that pops up a MsgBox, and it works fine.
  

Help! What am I missing? What would make this one PC shut down Excel the moment the file is opened?

Thanks for any suggestions!
Russell