Automatic Activation of Design Mode

M

Melissa Matile

Help! When I execute a procedure to import a text file
into Excel, the Design Mode is automatically engaging,
which then doesn't allow the procedure to process any
further actions past the open text file. How do I stop
this?
 
T

Tom Ogilvy

Never heard of anything like that.

Perhaps you should show the code around the spot where you think this is
happening. How do you know you are in design mode?
 
M

Melissa

The procedure is simple. One line:
Workbooks.OpenText "c:\class\JuneData.txt"

If the procedure is triggered by a keyboard shortcut, then
Design Mode is activated (you can tell by the button on
either the VB toolbar or the Control Toolbox).

If the procedure is triggered by clicking Run in the Run
Macro dialog box, then Design Mode is not activated.

It's insane and I can't figure out what the problem is.

mmm
 
Top