Hi,
I have a workbook with several sheets and a lot of macros.
I have protected the VBA project and also the sheets and all the macros are private.
What I'm wondering is if there's a way to prevent users from unintentionally run macros
from the macro menu (Alt + F8). I know that if the macros are private they wil not show
in this menu, but if a macro is named "A" and someone type "A" in the macro meny they will be able to run it.
I need macros to be run on the right sheet only, else it can delete other codes on the sheet.
Hope someone can help me out here
Thomas
Bookmarks