How to run module in visual basic editor

**jewellove** · 10-29-2012, 09:29 PM

I have Opened a workbook and start the Visual Basic Editor (Alt + F11). Right Clicked in the project explorer window and selected Insert > Module. Copied the code into the new Module then suppose to select Run and all worksheets should be Unprotected in that Workbook. I have done everything except select run.. Where is the select run button. Thank you...

**6StringJazzer** · 10-29-2012, 09:38 PM

If you just want to test your code from the Visual Basic Editor, you can run a Sub by either of the following:

Position the text cursor anywhere inside the Sub then press F5
From the menu, select Run, then "Run Sub, UserForm"

For other ways to run your macro:

From your Excel worksheet, you can select Developer, Macros, then find the macro in the list and press Run (the macro will have to be declared as Public for it to be visible here)

You can create a button that is visible from your worksheet to cause the macro to run.