G Guest Oct 19, 2004 #1 I can't get some projects to work without turning it off but have no idea how to do it.
T Tom Ogilvy Oct 19, 2004 #2 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.
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.
A Andy Pope Oct 19, 2004 #3 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
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