VBA Trick of the Week :: Hiding Members of Enum

Posted: July 19, 2013 by Transformer in Excel, VBA
Tags: , ,

If you want to prevent a member of Enum from being displayed in VB editor’s intellisense then it can be done by prefixing them with ‘_’ and then putting them in square brackets.
e.g.

Enum Role
     AVP
     Manager
     Analyst
     [_HideMe]
End Enum

Enum

In the above image it can be seen that [ _HideMe] is not displayed in intellisense.

Share your thoughts/feedback