Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I hide macro list from user?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I hide macro list from user?
Precede the macro name with the keyword Private; e.g.:
Private Sub MyMacro() '.......... End Sub -- Vasant "Bill_S" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I hide macro list from user?
If I label the macro private then how does VBA call the private sub
-- Jim at Eagle "Vasant Nanavati" wrote: Precede the macro name with the keyword Private; e.g.: Private Sub MyMacro() '.......... End Sub -- Vasant "Bill_S" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I hide macro list from user?
Don't the macros that will be called from a commandbar button (to start your
macro) or menu have to be Public? The others can all be Private. -- Regards, Bill "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Precede the macro name with the keyword Private; e.g.: Private Sub MyMacro() '.......... End Sub -- Vasant |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I hide macro list from user?
If all the modules are only callable from your project in V BA, the precede
the module with Option Private Module -- HTH Bob Phillips "Bill_S" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide macros from Alt-F8 macro list | Excel Discussion (Misc queries) | |||
Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
Hide columns to all but one user? | Excel Discussion (Misc queries) | |||
Hide code from user | Excel Programming | |||
Hide code from user | Excel Programming |