Option Explicit

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
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."
 
Open VBE. Click on Tools | Options. Make sure the checkbox for "Require
variable declaration" on "Editor" tab is clicked.
 
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."
 
Back
Top