View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sparx
 
Posts: n/a
Default 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.


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