Is there a way I can prevent macros from appearing in the macro list
(Alt-F8.) I developed a custom Excel application and I password protected the
VBA project as well as the workbook and all worksheets. Yet, when the user
selects Alt-F8 he can still view and run any of the dozens of macros. This
could have disastrous consequences. How can I hide the macros from the Alt-F8
macro list?

thank you,

Option private module at the top of the module

--
Don Guillett
SalesAid Software

"Bill_S" wrote in message
...
Is there a way I can prevent macros from appearing in the macro list
(Alt-F8.) I developed a custom Excel application and I password protected
the
VBA project as well as the workbook and all worksheets. Yet, when the user
selects Alt-F8 he can still view and run any of the dozens of macros. This
could have disastrous consequences. How can I hide the macros from the
Alt-F8
macro list?

thank you,

Change them to Private

Private Sub mymacro()
'your code
End Sub

Users could still run the macros from ToolsMacroMacros if they know the names
of the macros.


Gord Dibben MS Excel MVP



On Thu, 4 Jan 2007 10:51:02 -0800, Bill_S
wrote:

Is there a way I can prevent macros from appearing in the macro list
(Alt-F8.) I developed a custom Excel application and I password protected the
VBA project as well as the workbook and all worksheets. Yet, when the user
selects Alt-F8 he can still view and run any of the dozens of macros. This
could have disastrous consequences. How can I hide the macros from the Alt-F8
macro list?

thank you,