Hide Macro's in Toolbar / Macro's list

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.

Use this at the top of the module

Option Explicit
Option Private Module



--
Regards Ron de Bruin
http://www.rondebruin.nl


"sparx" <sparx.27eg9m_1146941700.8626@excelforum-nospam.com> wrote in message
news:sparx.27eg9m_1146941700.8626@excelforum-nospam.com...
>
> 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.
>
>
> --
> sparx
> ------------------------------------------------------------------------
> sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
> View this thread: http://www.excelforum.com/showthread...hreadid=539558
>

Hi there - thank you so much.