unwanted design mode during macro exection
 

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?

unwanted design mode during macro exection
 

You will need to post the code. Cannot duplicate the error with the data
provided.

"mrsthree" wrote:

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?

unwanted design mode during macro exection
 

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

"JLGWhiz" wrote:

You will need to post the code. Cannot duplicate the error with the data
provided.

"mrsthree" wrote:

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?