Excel Made Easy

VBA thisworkbook in Excel

ThisWorkbook property returns a Workbook object that represents a workbook where the code is executing.

This returns a Read-Only object.

Thisworkbook property can be used to to refer to the workbook that contains your macro code.

Thisworkbook property is the only way to refer to an add-in workbook from inside the add-in itself.

To understand the above point, while creating an Add-in, the workbook's name may change, so by using "Thisworkbook", the same workbook is always referenced irrespective of its name.

The following example illustates this property:

A screenshot from the editor is as shown below:

The output is as shown below:

You can find similar Excel Questions and Answer hereunder

1) Vba code to password protect workbook in Excel

2) How to do workbook protection with VBA in Excel

3) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

4) Calling a macro from another workbook in Excel

5) How to protect your workbook in Excel

6) I want to automatically run an initialization procedure whenever I open my WorkBook so that it is ready for use - how can I achieve that?

7) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

8) How can I save a WorkSheet as a new WorkBook using VBA?

9) How do I disable the right click option for users in my WorkBook?

10) How do you close, save, open files and do other operations in the workbook in VBA