unwanted design mode during macro exection

  • Thread starter Thread starter mrsthree
  • Start date Start date
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?
 
You will need to post the code. Cannot duplicate the error with the data
provided.
 
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...)
 
You must log in or register to reply here.

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

turn off design mode 2
When something in module is shown as a macro 3
Unable to exit Design Mode 4
Macro doesn't execute fully using shortcut 6
migrate xls app 2003 to 2007 -- get custom macro button out of des 3
Excel 2007 Design Mode 3
Turn screen update off; then back on during macro 3
How do I get an Excel macro to run completely using the keyboard? 5

Back
Top