how can I hide macro list from user?

B

Bill_S

I created a workbook with several macros. I password-protected the workbook,
the sheets and even the VBA project from viewing. Still, the entire macro
list pops up when the user pulls up the macro list (Tools|Macro|Macros or
Alt+F8.) I don't want the user to see the list of macros hidden in the
workbook. How can I hide the list from the user?
 
R

Rick Budde

You should ask this question in the Excel newsgroup. This
is the Front Page newsgroup.
 
D

Dave Clark

Bill_S said:
I don't want the user to see the list of macros hidden in the
workbook.
Click to expand...

Any VBA subroutine that is marked PUBLIC will show in that list.
Change them to PRIVATE and move them from the global module to the userform
or worksheet module from which these macros are actually called. Your VBA
code will still be able to call/invoke them, then, but they will no longer
show up as macros.

Dave

www.DaveClarkConsulting.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Show customUI when I launch the contextMenu from a VBA macro 0
How to create portable Excel applications? 2
Enabling Macros message when NO macros in workbook 3
VBA for Dependents shortcut menu 0
Problem in adding macro to ribbon through Add-in 7
How to call Excel add-in macro from a button… 1
Hide macro List from Alt+F8 window. 16

Top