+ Reply to Thread
Results 1 to 4 of 4

New to Office 365 - why do VBA modules not show under ThisWorbook?

  1. #1
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    New to Office 365 - why do VBA modules not show under ThisWorbook?

    In previous office versions, I've always seen VBA modules show within the VBA Project after the 'ThisWorkbook' entry. In Office 365 Excel, the modules are sorted alphabetically with the sheet entries.

    For example:
    VBA Project (Name)
    Functions1
    Module1
    Module2
    Sheet1
    Sheet2
    Test_Module
    ThisWorkbook

    Am I missing some setting? How do I get the modules to show after the 'ThisWorkbook' entry?
    Thanks.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: New to Office 365 - why do VBA modules not show under ThisWorbook?

    Hi, what's the file extension?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: New to Office 365 - why do VBA modules not show under ThisWorbook?

    Click the Toggle Folders button at the top of the Project Explorer window.
    Rory

  4. #4
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Re: New to Office 365 - why do VBA modules not show under ThisWorbook?

    Thanks rorya. That did it.

+ 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. macro 4 sheet Mysterious appearing Worksheets & Modules. Codes transferred to New Modules
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-24-2016, 07:07 AM
  2. Properties of Modules in VB editor missing (Office 365 - Mac - Yosemite)
    By crehan57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2015, 09:28 AM
  3. migrating VB modules into Office 2003
    By mkingsley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2006, 01:14 PM
  4. Is it safe to add event proc. to ThisWorbook module, if yes how?
    By mikeb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2006, 10:50 AM
  5. [SOLVED] Public, Private, Event modules, Forms modules,,,
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-31-2005, 12:05 AM
  6. [SOLVED] Basic question - modules and class modules - what's the difference?
    By Mark Stephens in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-08-2005, 07:08 AM
  7. [SOLVED] How to write a macro to import an event procedure to ThisWorbook?
    By utdcr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2005, 07:06 PM

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