+ Reply to Thread
Results 1 to 4 of 4

VBScript window no longer showing code but macros still work?

  1. #1
    Registered User
    Join Date
    08-03-2019
    Location
    Illinois
    MS-Off Ver
    Mac 14.7.7
    Posts
    17

    VBScript window no longer showing code but macros still work?

    This is such a weird issue and it's probably something simple but I cannot figure it out. I have an excel workbook that I have had vbscript in for years. Today when I opened it to look at the VSscript code, there was no code visible. I could see the module but when I double clicked to open it and look at it, the code area was empty. I can see that the macros are still there and they work BUT I can no longer see the actual code. Is there some preference that I somehow have to reset? It's very strange. Never had this happen before.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,416

    Re: VBScript window no longer showing code but macros still work?

    What is the name of the module that has your code? Do you have other Excel files open at the same time? Normally I would suggest attaching the file but in this case in might help to show a screen shot of your VBA development window (not VBScript, by the way, which is a different language). My guess just from what your described would be that you are looking at an empty module with the same name in a different file.

  3. #3
    Registered User
    Join Date
    08-03-2019
    Location
    Illinois
    MS-Off Ver
    Mac 14.7.7
    Posts
    17

    Re: VBScript window no longer showing code but macros still work?

    Got it figured out. I had just updated to the latest Excel and it had moved the vbscript window offscreen for some reason. Thx for responding.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,416

    Re: VBScript window no longer showing code but macros still work?

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. All my macros no longer work
    By Scshot in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-18-2018, 01:52 PM
  2. [SOLVED] Created macros and links between two worksheets no longer work.
    By billfinnjr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2018, 10:18 AM
  3. [SOLVED] Convert some working VBA code to work in VBScript [Test File State]
    By dlow in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-28-2015, 07:52 PM
  4. All Code in Recently Saved Files Will No Longer Work
    By masouder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2015, 03:21 PM
  5. Upgrade to Windows 7, attachment prompt no longer opens (VBScript)
    By Haze1434 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 03:45 AM
  6. New Laptop, macros no longer work...
    By malcolmlo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 02:32 PM
  7. [SOLVED] Immediate Window not showing up below code window
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 08:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1