+ Reply to Thread
Results 1 to 3 of 3

Possible to hide a sub in the view macro list?

  1. #1
    Registered User
    Join Date
    06-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    92

    Question Possible to hide a sub in the view macro list?

    Hello all, we currently have lots of different subs doing lots of different things, and was wondering if there's any code we can add or change to make it so that the only subs that appear in the "View Macros" list are the ones we define.

    Regards, Usman.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,339

    Re: Possible to hide a sub in the view macro list?

    If you make your subs private they will not appear in the macros dialog. You can also add Option Private Module to the top of a module to hide all routines in that module from the dialog.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    06-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: Possible to hide a sub in the view macro list?

    That worked perfectly, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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