Where is the workbook module in excel

The following example activates Sheet1 in the workbook named Cogs. The ActiveWorkbook property of the Application object returns the workbook that's currently active. The following example sets the name of the author for the active workbook.

This example emails a worksheet tab from the active workbook by using a specified email address and subject. To run this code, the active worksheet must contain the email address in cell A1, the subject in cell B1, and the name of the worksheet to send in cell C1. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Save your workbook as " Excel macro-enabled workbook ". The " Save as " dialog will open. Choose " Excel macro-enabled workbook " from the " Save as type " drop-down list and click the Save button.

Then select the wanted macro from the "Macro Name" list and click the "Run" button. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical.

Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! The Project Explorer is like Windows Explorer and you can see all your open workbooks and add-ins there. Normal the active project workbook is expand so you can see all the modules in it. When you use Option Explicit you must explicitly declare all variables.

If you attempt to use an undeclared variable name, an error occurs at compile time. It avoid incorrectly typing the name of an existing variable and avoid confusion in code where the scope of the variable is not clear.