Hide Macros (VBA) from the User in Excel

Add to Favorites
Author: | Edits: don

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.

 

 

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...
Return the ISO Week Number from a Date in Excel - UDF
Macro: Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF (user defin...