Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Cannot read the VBA code as it disappears immediately
Register FAQ Mark Forums Read

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: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
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: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
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: 137
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?
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's Avatar
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: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Does it still happen if you opt to disable Macros/VBA?
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 AM.

Contact Us - Privacy Statement - Top

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