unwanted design mode during macro exection

M

mrsthree

I have a macro that runs perfectly when I run it from the Visual Basic
Editor. However, if I run it from Excel (using a keyboard shortcut), it gets
to the command ActiveWindow.ActivateNext. Instead of going to the next Excel
window, it turns on Design Mode in Excel. How can I prevent this from
happening? Or what is the code to turn it back off immediately so the macro
continues properly?
 
M

mrsthree

Thanks for your help. I am going to give up on this one. I can't get the
error to repeat today either. (It's still not working...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro doesn't execute fully using shortcut 6
When something in module is shown as a macro 3
Turn ON design mode... 8
How do I get an Excel macro to run completely using the keyboard? 5
run procedure when exit design mode 3
Excel 2007 Design Mode 3
Can't get into design mode in Excel 2007 3
Macro Compatibility between 03 and 07 2

Top