ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can I cancel a macro in excel? (https://www.excelbanter.com/excel-programming/350788-how-can-i-cancel-macro-excel.html)

Nanou

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!!!!



Kevin B

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!!!!



ljsmith[_6_]

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


Nanou

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!!!!



Nanou

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!!!!



Nanou

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!!!!



Kevin B

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!!!!



Nanou

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!!!!



Nanou

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