excel - Disable running macros from the "View Macro" screen until VBA project password is entered? -


so first, when 1 clicks on "view macro" button, pops up:

view macros window

what want know is, there code can run on workbook open (and "unrun" on workbook close) grays out run button (like others underneath are) until password entered in vba project (using alt+f11 open editor)?

i don't want users able run of these subs manually.

if declare sub needs input, optional input not show in list either.

sub test(optional string) 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -