Hide Macros (VBA) from the User in Excel

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:

• Preventing the user from seeing your macros in the View Macros window.
• Hiding macros from the Assign Macro window.
• Stopping the user from viewing any of the VBA code in your project or running the code from there.
• Connecting private macros and modules with public facing interface macros and modules to create a user-friendly and programmer-friendly setup.