Thanks for both of the replies

"narutard" wrote:


i'm not sure about putting the actual coding itself but you can export
(file/export)your macro on your hard drive somewhere and then delete
the macro from the xl save file. However, you need to open the macro
everytime you open the file but others cannot use the macro since they
don't access to it

hope that helps


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=389033