excel vba - Do not allow specific sub/macro to be run -
quick question - there way can stop macro (and not others) showing on alt-f8 screen disallowing sub beingness run? have sub smaller part of programme not create sense utilize alone.
see if making private makes sense in context, solves issue
private sub test() msgbox "cant see me " end sub public sub hello() msgbox "see me" end sub only hello shown on pressing alt+f8
excel-vba
No comments:
Post a Comment