none
VBA Module and password RRS feed

Answers

  • WLID1966,

    Your question of the day.

    Open the VBE with the macro of interest displayed in the code window. Then go to Tools/VBA Project Properties/Protection tab. Set your password as desired. But, be careful, if you forget the password, you're dead.

    Hope this helps.

    John

    • Marked as answer by WLID1966 Thursday, October 15, 2015 9:30 AM
    Wednesday, October 14, 2015 9:25 PM

All replies

  • WLID1966,

    Your question of the day.

    Open the VBE with the macro of interest displayed in the code window. Then go to Tools/VBA Project Properties/Protection tab. Set your password as desired. But, be careful, if you forget the password, you're dead.

    Hope this helps.

    John

    • Marked as answer by WLID1966 Thursday, October 15, 2015 9:30 AM
    Wednesday, October 14, 2015 9:25 PM
  • Thanks one more time John!

    Thursday, October 15, 2015 9:31 AM
  • WLID1966,

    You're welcome and thanks for the feeback.

    John

    Thursday, October 15, 2015 2:15 PM