Hide macros from Alt-F8 macro list
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, |
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, |
Hide macros from Alt-F8 macro list
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, |
All times are GMT +1. The time now is 08:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com