![]() |
how can I cancel a macro in excel?
Hello,
I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Open Excel, click on Tools in the menu, click Macro in the drop-down menu,
Macros from the cascade menu, and in the dialog box that is displayed, select the macro you wish to remove and click the Delete button in the lower-right portion of the dialog box. Repeat for any and all macros you wish to remove. -- Kevin Backmann "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Kevin B Wrote:[color=blue] Open Excel, click on Tools in the menu, click Macro in the drop-dow menu, Macros from the cascade menu, and in the dialog box that is displayed select the macro you wish to remove and click the Delete button in th lower-right portion of the dialog box. Repeat for any and all macros you wish t remove. -- Kevin Backmann "Nanou" wrote: This can also happen if someone has used Control Toolbox to creat textboxes, checkboxes, radio boxes etc. Excel will pick it up as macro, even though there isn't one present -- ljsmit ----------------------------------------------------------------------- ljsmith's Profile: http://www.excelforum.com/member.php...fo&userid=3053 View this thread: http://www.excelforum.com/showthread.php?threadid=50255 |
how can I cancel a macro in excel?
Hello all,
Yes that thing did not work, but I got the solution on the web, here is the link for any one who needs it. It worked perfectly for me !!!! ;-) http://www.contextures.com/xlfaqMac.html#NoMacros thanks again and you are the best guys !!!!! "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Hi Guys,
Thanks a lot for your response but it can not work since I beleive the macro was deleted. However I could find the solution on the web and it worked perfectly for me!!! Here is the link in case any one needs it! http://www.contextures.com/xlfaqMac.html#NoMacros Thx again...u r the best ;-) "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Guy I need yr help once more, :-/
Ok the macro is cancelled but now whenver I work on the file and save of course, there is a file (copy of the original) created and it is duplicated proportionnally on how many time I save the file when it is opened! Any idea what's happening here .... Nanou "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
It sounds like the file is an Excel Template file, which has an extension of
..xlt. Do a file save as and change the file type to an .xls workbook format. -- Kevin Backmann "Nanou" wrote: Guy I need yr help once more, :-/ Ok the macro is cancelled but now whenver I work on the file and save of course, there is a file (copy of the original) created and it is duplicated proportionnally on how many time I save the file when it is opened! Any idea what's happening here .... Nanou "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Good morning Kevin and all,
I tried your idea but I still get duplicated files as many times as I save the file. The file is an exel workbook type!!! Kind of lost here!!! Thx for any ideas.... "Kevin B" wrote: It sounds like the file is an Excel Template file, which has an extension of .xlt. Do a file save as and change the file type to an .xls workbook format. -- Kevin Backmann "Nanou" wrote: Guy I need yr help once more, :-/ Ok the macro is cancelled but now whenver I work on the file and save of course, there is a file (copy of the original) created and it is duplicated proportionnally on how many time I save the file when it is opened! Any idea what's happening here .... Nanou "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
how can I cancel a macro in excel?
Hello Kevin,
Just as a note I have transfered the contain of the file to another one that I created from scratch....so every body can work into it without pb. But I still wanna know how to resolve the issue with the old file!!!! "Kevin B" wrote: It sounds like the file is an Excel Template file, which has an extension of .xlt. Do a file save as and change the file type to an .xls workbook format. -- Kevin Backmann "Nanou" wrote: Guy I need yr help once more, :-/ Ok the macro is cancelled but now whenver I work on the file and save of course, there is a file (copy of the original) created and it is duplicated proportionnally on how many time I save the file when it is opened! Any idea what's happening here .... Nanou "Nanou" wrote: Hello, I am working on a workbook where there has been created a macro. This should not happen, now I am trying to cancel that so I dont get the message to enable or disable the macro every time I open the file. Any help is appreciated!!!! |
All times are GMT +1. The time now is 12:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com