Thread
:
Hide macros from Alt-F8 macro list
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Hide macros from Alt-F8 macro list
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,
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett