View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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,