How Do I Open File???

T

tkaplan

I have a big problem.
In my workbook load i have code that opens a form.
The problem is that i set the properties of the form in such a way that
it never lets the form open up - it puts it through an endless loop.

Is there a way that i can open up the workbook without executing the
code in the workbook open?
 
D

dominicb

Good afternoon tkaplan

Hold down the shift key while the workbook opens up. That will stop
any auto executing macros from running.

HTH

DominicB
 
T

tkaplan

I tried that but it didnt work if i opened up the file directly.
When I open up excel and open the file from there then it does work.

THank you.:)
 
D

dominicb

Hi tkaplan

Just to satisfy my own curiosity, can I ask what your security settin
is set to (Tools > Macro > Security)?

Dominic
 
T

tkaplan

oh it's low. i work with way too many macros to have the patience t
tell it which to enable and which to disable. it's probably not so wis
but ...
 
D

dominicb

Hi tkaplan

Just being nosey! Thanks for the prompt response.

But you could have set it to medium, opened the file, had it disabl
macros and reset it to low. Just a thought...

Dominic
 
Top