Removing disabled Macro
in [Functions]
|
From: Nadine on 6 May 2010 13:48 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.
From: Gary''s Student on 6 May 2010 14:03 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. >
From: Nadine on 6 May 2010 14:07 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. > >
From: Luke M on 6 May 2010 15:33 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" <Nadine(a)discussions.microsoft.com> wrote in message news:FB7BB229-7359-4F6B-894B-DD122D1C93CC(a)microsoft.com... > 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. >> >
From: Gary''s Student on 6 May 2010 15:52 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. > > >
|
Next
|
Last
Pages: 1 2 Prev: Incorporating Cell color fill in an "if" logical function? Next: Conditional Formatting |