Here is a simple way to prevent the user from seeing the macros that are in an Excel workbook.
This tutorial also covers a simple system for implementing front-facing macros that are visible to the user and that can be assigned to buttons while hiding the macros that should not be directly accessed.
This tip covers multiple scenarios, including: