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

Use this at the top of the module

Option Explicit
Option Private Module



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


"sparx" wrote in message
...

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.


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=539558