I can't get some projects to work without turning it off but have no idea how
to do it.

select the line that says

Option Explicit

at the top of the module and delete it.

Of course the standard advice is to fix the problems identified by Option
Explict - otherwise, you may not get correct results even it it runs.

--
Regards,
Tom Ogilvy


"glen" wrote in message
...
I can't get some projects to work without turning it off but have no idea
how
to do it.

Hi,

For existing code you can simply comment out the Option Explicit line.

To stop it automatically appearing at the top of new code use the menus
within VBE, Tools Options. On the editor tab is a checkbox 'Require
Variable Declaration'.

Cheers
Andy

glen wrote:

I can't get some projects to work without turning it off but have no idea how
to do it.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info