Darin:
This will prevent the user from accessing the macro from the Tools
menu.

Sub macro1_(Optional_HideRoutine_As_Integer)_

Brian M.


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=540314