Place two buttons in this worksheet that executes your code from the VBA worksheets. Please make sure that the buttons link to the CODE you maked, not simply the worksheets themselves.

Use a FORM CONTROL BUTTON for VBA Part 1 and make your button say "Show VBA Part 1".

Use an ACTIVEX CONTROL to make a button to open the Userform from VBA Part 2. This button should show text "Show VBA Part 2".

When finished HIDE this worksheet so it cannot be unhidden from the front end of excel but must be unhidden either from the VBA pane or with code.