MrExcel.com - Your One Stop for Excel Tips & Solutions

Hiding macros

Posted by Rachel Rabinowitz on January 11, 2001 8:14 AM

I posted a message but think it was misunderstood. I want to know if there's any way to hide my macros so people can't run them from teh tools menu (without making each sub private)
Thanks,
Rachel

Posted by Carl Rardon on January 11, 2001 8:59 AM

Including an (optional) argument with data type will remove a macro from the macro list.
E.g. Sub MyMacro(optional i as integer)

Posted by Rachel Rabinowitz on January 15, 2001 6:49 AM

Thanks so much,
That worked like a charm!!!