How to Run a Macro Automatically When Workbook Opens in Excel?
Tags: torunamacroautomatic, vbamacros
Published: 2021-09-04 01:54:38

---
title: How to Run a Macro Automatically When Workbook Opens in Excel?
published: true
date: 2021-09-03 14:24:44 UTC
tags: ToRunAMacroAutomatic,VBAMacros
canonical_url: https://geekexcel.com/how-to-run-a-macro-automatically-when-workbook-opens-in-excel/
---

In this article, you will learn  **how to run a Macro automatically when Workbook opens in Excel Office 365**. Let’s see them below!! Get the official version of  **MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Auto Run Macro When Workbook Closes

- To **run macro as the workbook opens** , you have to use **Workbook Event Workbook\_Open**.
- The  **syntax ** of this event is given below.

```
Private Sub Workbook_Open()

 'Your Code here.

End Sub

```

- Firstly, in the Excel Worksheet, you have to go to the  **Developer Tab.**
- Then, you need to ** ** select the  **Visual Basic**  option under the  **Code**  section.

![](https://geekexcel.com/wp-content/uploads/2021/09/Select-Visual-Basic-5-1024x180.png)<figcaption>Select Visual Basic</figcaption>

- Now, in  **project explorer** , you have to find  **ThisWorkbook object**  in project explorer and  **double-click**  on it.

![](https://geekexcel.com/wp-content/uploads/2021/09/find-ThisWorkbook-object-1.png)<figcaption>Find ThisWorkbook object</figcaption>

- After that, you have to  **copy and paste the code**  given below.

```
 Private Sub Workbook_Open()ps = 12345

pw = InputBox("Please enter the password.") + 0

If pw = ps Then

 MsgBox ("Welcome Sir!")

Else

 MsgBox ("Goodbye")

 ThisWorkbook.Close

End If

End Sub

```

- You need to  **save the code**  by selecting it and then  **close the window**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Save-the-code-6.png)<figcaption>Save the code</figcaption>

- Again, you have to go to the  **Excel Spreadsheet** , and click on the  **Developer Tab**.
- You need to choose the  **Macros option**  in the Code section.

![](https://geekexcel.com/wp-content/uploads/2021/09/Choose-Macro-option-5-1024x184.png)<figcaption>Choose Macro option</figcaption>

- Then, you have to **Save the workbook** and **run the code once**.
- Now, you need to **Close the workbook** and try to **open** it.
- After that, the **code will run** as soon as the **workbook opens** , and you have to **enter the password**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Enter-the-password-1024x447.png)

- Finally, you will receive the **message box with Welcome Sri**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Welcome-Sri-1024x571.png)<figcaption>Final output</figcaption>

## Wind-Up

We hope that this short tutorial gives you guidelines on **how to run a Macro automatically when Workbook opens in Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[How to Create and Insert Auto Text Entry in Excel Office 365?](https://geekexcel.com/how-to-create-and-insert-auto-text-entry-in-excel-office-365/)**
- **[Excel VBA Loops Statements in Office 365 ~ With Examples!!](https://geekexcel.com/excel-vba-loops-statements-in-office-365-with-examples/)**
- **[Excel VBA Decisions in Office 365 ~ Easy Tutorial for You!!](https://geekexcel.com/excel-vba-decisions-in-office-365-easy-tutorial-for-you/)**
- **[Auto Resize Comment Boxes to Fit the Contents in Excel Office 365!!](https://geekexcel.com/auto-resize-comment-boxes-to-fit-the-contents-in-excel-office-365/)**