View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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?