Microsoft Office Forums Cannot read the VBA code as it disappears immediately

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2019, 04:55 AM
Jan Rennel Jan Rennel is offline Cannot read the VBA code as it disappears immediately Windows 7 32bit Cannot read the VBA code as it disappears immediately Office 2007
Novice
Cannot read the VBA code as it disappears immediately
 
Join Date: May 2019
Posts: 3
Jan Rennel is on a distinguished road
Smile Cannot read the VBA code as it disappears immediately

Hi,

My VBA code disappears immediately when I try to open the VBA file.

I suppose it is a question of enable/disable but how to get it function?

I want to have the code enabled if this is the problem.

Can someone help me?

Best regards,



Jan
Reply With Quote
  #2  
Old 05-16-2019, 08:41 AM
Logit Logit is offline Cannot read the VBA code as it disappears immediately Windows 10 Cannot read the VBA code as it disappears immediately Office 2007
Expert
 
Join Date: Jan 2017
Posts: 252
Logit is on a distinguished road
Default

Is this something you created or did someone else create the code ?

Can you post your workbook for review ?
Reply With Quote
  #3  
Old 05-16-2019, 10:00 AM
Jan Rennel Jan Rennel is offline Cannot read the VBA code as it disappears immediately Windows 7 32bit Cannot read the VBA code as it disappears immediately Office 2007
Novice
Cannot read the VBA code as it disappears immediately
 
Join Date: May 2019
Posts: 3
Jan Rennel is on a distinguished road
Smile Cannot read the VBA code as it disappears immediately

Hi,

I have created the VBA code.

Kind regards,
Jan
Reply With Quote
  #4  
Old 05-16-2019, 12:13 PM
Logit Logit is offline Cannot read the VBA code as it disappears immediately Windows 10 Cannot read the VBA code as it disappears immediately Office 2007
Expert
 
Join Date: Jan 2017
Posts: 252
Logit is on a distinguished road
Default

You still need to post it here for review.
Reply With Quote
  #5  
Old 05-17-2019, 10:46 PM
Lugh's Avatar
Lugh Lugh is offline Cannot read the VBA code as it disappears immediately Windows 10 Cannot read the VBA code as it disappears immediately Office 2016
Competent Performer
 
Join Date: May 2019
Location: USA
Posts: 112
Lugh is on a distinguished road
Default

Quote:
Originally Posted by Jan Rennel View Post
My VBA code disappears immediately when I try to open the VBA file.
So you press Alt+F11, the VBA editor appears briefly, and then closes. Is that what's happening?
__________________
Windows 10 Home x64 1803, Office 365 monthly channel
Main MSOs: Word, Excel, Access, OneNote, Outlook
Reply With Quote
  #6  
Old 05-18-2019, 04:57 AM
Jan Rennel Jan Rennel is offline Cannot read the VBA code as it disappears immediately Windows 7 32bit Cannot read the VBA code as it disappears immediately Office 2007
Novice
Cannot read the VBA code as it disappears immediately
 
Join Date: May 2019
Posts: 3
Jan Rennel is on a distinguished road
Smile

Hi,
Yes, that is what happpens.
Best regards,
Jan
Reply With Quote
  #7  
Old 05-18-2019, 10:41 AM
p45cal p45cal is offline Cannot read the VBA code as it disappears immediately Windows 10 Cannot read the VBA code as it disappears immediately Office 2016
Expert
 
Join Date: Apr 2014
Posts: 281
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Does it still happen if you opt to disable Macros/VBA?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
full font characters not appearing immediately Nayan Nepal Excel 0 06-28-2016 07:02 AM
Cannot read the VBA code as it disappears immediately Find results not showing immediately Roysyboy Word 4 05-05-2016 08:00 AM
Cannot read the VBA code as it disappears immediately VBA code to read number of footnote and enter in text rekent Word VBA 2 05-13-2014 06:53 AM
VBA to immediately change the colour of a cell depending on the code placed in anothe Phil Payne Excel Programming 2 07-27-2013 11:04 PM
Help-urgent help needed immediately munstershug PowerPoint 1 05-01-2010 11:27 AM


All times are GMT -7. The time now is 09:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft