Re: novice question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This is because the module that the macro was in still exists.

What you need to do is
- go into the VBE
- select the module in the project explorer pane
- menu File>Remove Module (probably Module1)
- say no to exporting it first

--
HTH

Bob Phillips

"Qiset" <Qiset.1t6tak_1123070711.6757@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Qiset.1t6tak_1123070711.6757@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I played with creating a macro. Now even though I've deleted the macro
> I get a warning asking me to disable or enable macros every time I open
> the file. Why is this happening and how can I rid myself of
> this?
>
> thanks,
>
> Q
>
>
> --
> Qiset
> ------------------------------------------------------------------------
> Qiset's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25865
> View this thread: http://www.excelforum.com/showthread.php?threadid=392469
>


.

Relevant Pages

  • Re: How do I . . .
    ... What happens if you run your AutoOpen macro directly in the vbe editor? ... Intermediate User's Guide to Microsoft Word (supplemented version of ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ...
    (microsoft.public.word.vba.beginners)
  • Re: Change Cell Background color when Cell changes
    ... That's a good suggestion - much simpler than programming to the VBE. ... > Steve and Rowan, ... >> you only wanted the macro to work in Cell A5 you could do something like ... >>> clicking a button it disables it? ...
    (microsoft.public.excel.programming)
  • Re: dropdown list to activate Macro
    ... I thinkwhat you need here is to use the Worksheet_Change event in the VBE. ... snippet and this is where you should fit your macro if you want it to ... > a single cell. ... Thanks, Brad ...
    (microsoft.public.excel.programming)
  • VBE freezes after running macros
    ... I have been having a problem with the VBE editor freezing after I run ... After the macro ends, I enter VBE, and the editor is ... Private Sub CommandButton1_Click ...
    (microsoft.public.excel.programming)
  • Re: Orlandos calendar
    ... You can run the following from the Intermediate window in the VBE ... Alt+G to bring up the Intermediate Window ... The following macro will do the same and a bit more, ... > No indication that the calendar is even loaded in this WB ...
    (microsoft.public.excel.worksheet.functions)