+ Reply to Thread
Results 1 to 2 of 2

Hide module instead of delete

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Kannada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Hide module instead of delete

    Below code deletes a module:

    Dim md As Object
    Set md = Application.VBE.ActiveVBProject.VBComponents
    md.Remove VBComponent:=md.Item("Module1")

    How can I hide a module instead of deleting it?
    Last edited by Peepay; 03-31-2024 at 02:28 PM.

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,541

    Re: Hide module instead of delete

    I think there is no such possibility.
    Can you zoom in on your problem? Why would you want to hide the module(s)?

    Artik

+ 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. Chartobject in module 1 delete it in module 2
    By YFM_eng in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2021, 06:10 AM
  2. Completely hide a VBA module from outside access
    By iamparrth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2020, 09:08 AM
  3. Hide Module for certain users
    By MaxOtis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-05-2017, 11:34 PM
  4. Module to Hide Columns
    By montego in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 09:02 PM
  5. Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2005, 08:12 PM
  6. [SOLVED] Re: Macro to delete sheets and saves remaining file does not properly delete module
    By bhawane in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 PM
  7. Re: Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 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