Hide Macro's in Toolbar / Macro's list

[sparx]

I want to be able to make all the macro's in my file hidden so if you go
to Tools, Macro, Macro's > you wont see the file macro's and simply run
macro's that turn specific items off. All the effort taken to try and
stop people messing around with your file can be done there - so can
you write something at the top of each module that hides them. For
some reason the macro's written in the "ThisWorkbook" arnt displayed in
the Tools, Macro, Macro's > list.

 

[Ron de Bruin]

Use this at the top of the module

Option Explicit
Option Private Module

 

[sparx]

Hi there - thank you so much.