Removing disabled Macro
 

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

Removing disabled Macro
 

You need to remove the Modules as well as the macros they used to contain.
--
Gary''s Student - gsnu201002


"Nadine" wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

Removing disabled Macro
 

OK. How do I do that?

"Gary''s Student" wrote:

You need to remove the Modules as well as the macros they used to contain.
--
Gary''s Student - gsnu201002


"Nadine" wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

Removing disabled Macro
 

Open the VBE. In the VBAProject explorer window, navigate to the module.
Right-click on it, "Remove", and choose not to export it (I'm assuming).

--
Best Regards,

Luke M
"Nadine" wrote in message
...
OK. How do I do that?

"Gary''s Student" wrote:

You need to remove the Modules as well as the macros they used to
contain.
--
Gary''s Student - gsnu201002


"Nadine" wrote:

I had been playing with some macros in a book I have. I didn't think I
had
saved any of them. Now when I open that workbook, I get a message that
says
macros are disabled because the security level is set to High... I'd
like to
delete these macros that somehow got stored but when I go to Tools,
Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with
and
don't want to keep? Thank you.

Removing disabled Macro
 

In the Project pane in the VBA Window, right-click the Module and select
Remove module.
--
Gary''s Student - gsnu201002


"Nadine" wrote:

OK. How do I do that?

"Gary''s Student" wrote:

You need to remove the Modules as well as the macros they used to contain.
--
Gary''s Student - gsnu201002


"Nadine" wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

Removing disabled Macro
 

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Nadine wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

--

Dave Peterson

Removing disabled Macro
 

Thank you.

"Dave Peterson" wrote:

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Nadine wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.

--

Dave Peterson
.

one of the quickest way to disable/restrict the macros is

Saveas macro disable workbook.

Your macros will be automactically removed and disabled as well.