Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-16-2019, 04:55 AM
Jan Rennel Jan Rennel is offline Windows 7 32bit Office 2007
Novice
 
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 Windows 10 Office 2007
Competent Performer
 
Join Date: Jan 2017
Posts: 244
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 Windows 7 32bit Office 2007
Novice
 
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 Windows 10 Office 2007
Competent Performer
 
Join Date: Jan 2017
Posts: 244
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 Windows 10 Office 2016
Advanced Beginner
 
Join Date: May 2019
Location: USA
Posts: 33
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 Windows 7 32bit Office 2007
Novice
 
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 Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 253
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
Find results not showing immediately Roysyboy Word 4 05-05-2016 08:00 AM
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 10:06 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft