• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Excel 2007 when pressing on Macro button file running and not responding

in the past some expert gave me a link to a process to kill which stop the Macro and leave the file open
is some one know which process to terminate? for sure i know its possiable

Thanks
0
gvilbis
Asked:
gvilbis
  • 2
  • 2
  • 2
  • +1
5 Solutions
 
nike_golfCommented:
If it's a macro that's running you can try CTRL+BREAK to stop it.
0
 
gvilbisAuthor Commented:
and if its Save button?
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Will probably work, as long as the EnableCancelKey property has not been set to xlDisabled
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
gvilbisAuthor Commented:
where do i set the "EnableCancelKey " prperty?
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
See here about the EnableCancelKey
0
 
etech0Commented:
try pressing esc
0
 
nike_golfCommented:
If its a save button then I assume you are already in the workbook? If so then then just unlink the macro from the button...

Microsoft link on how to create a button and link a macro to it:
http://office.microsoft.com/en-us/excel-help/add-a-button-and-assign-a-macro-to-it-in-a-worksheet-HP010236676.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now