Option Explicit

J

Jonathan Blitz

Is there any way to make VBA automatically put Option Explicit at the start
of every new module so that I don't have to remember?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
K

Ken Snell

Open VBE. Click on Tools | Options. Make sure the checkbox for "Require
variable declaration" on "Editor" tab is clicked.
 
J

Jonathan Blitz

Thx

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top