Friday, 15 July 2011

excel vba - Do not allow specific sub/macro to be run -



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