Nashua,

Try putting this at the beginning of the module:

Option Private Module

Regards

Pete



"Nashua" wrote:


I've written an application and I've protected both the worksheets and
the VBA code. But the macros still show in Tools, Macros, Macros...

A user can still select and run a macro from the Tools menu. I want to
control all macros from the buttons I have on the various sheets of the
workbook. Can I hide the macro names and/or prevent "Run" from being
chosen?

Thanks in advance.
Nashua


--
Nashua
------------------------------------------------------------------------
Nashua's Profile: http://www.highdots.com/forums/m1420
View this thread: http://www.highdots.com/forums/t3078996