How to put "Option Explicit" by default

[KishorKK]

Hi All,

1. In VBA how to put "Option Explicit" by default.

2. After saving VBA i'm getting this, how to turn off this, some one help me

 

[bobhc]

1. In the Visual Basic Editor, click on Tools and then click on Options.

2. Check Require Variable Declaration.

Note: Option Explicit will not be added automatically to existing Excel files. Simply type in Option Explicit yourself if you want to use it.

Question two should have its own post as it will not show in any search as it is buried in a non related question so anyone searching for this answer will not find it.

Step by step instructions (for 2007):

1. Office orb
2. Excel options
3. Trust Centre
   
4. Trust Centre Settings...
5. Uncheck Remove personal information from file properties on save
6. OK
7. OK

.
.