How Do I Open File???
 

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?


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=471133

Good afternoon tkaplan

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471133

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.:)


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=471133

Hi tkaplan

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

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471133

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


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=471133

Hi tkaplan

Just being nosey! Thanks for the prompt response.

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

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471133

i just thought of that after you asked me what my security level was lol


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=471133