Makro in Excel

In Excel I created a makro, which was used to "reorganise" all 12 sheets in
the document. After running the makro, the makro was deleted and the document
was saved again under a new name.
Whenever I now open that particular document I'm asked, if I want the
document opened with or without makros.
How can this document be "cleaned", so I can open it without that
dialog-window about makros?

You need to remove the module where the code was saved, most likely, Module
1.

Press Alt-F11 to open the VBE. Right Click on the module, select "Remove
module..." and say "no" to saving a copy. Save the workbook and you're done

Regards

Trevor


"AndersTC" <[email protected]> wrote in message
news:[email protected]...
> In Excel I created a makro, which was used to "reorganise" all 12 sheets
> in
> the document. After running the makro, the makro was deleted and the
> document
> was saved again under a new name.
> Whenever I now open that particular document I'm asked, if I want the
> document opened with or without makros.
> How can this document be "cleaned", so I can open it without that
> dialog-window about makros?
>
>

"AndersTC" <[email protected]> wrote in message
news:[email protected]...
> In Excel I created a makro, which was used to "reorganise" all 12 sheets
in
> the document. After running the makro, the makro was deleted and the
document
> was saved again under a new name.
> Whenever I now open that particular document I'm asked, if I want the
> document opened with or without makros.
> How can this document be "cleaned", so I can open it without that
> dialog-window about makros?
>

You can sign the document if you want to keep the macro. I think there's a
tool in office that you can use to create a certificate.

/Fredrik

Thanks for prompt reply - and I have tried your solution, but unfortunately I
still have to respond whether to open the document with or without a macro.

Regards AndersTC

"Trevor Shuttleworth" skrev:

> You need to remove the module where the code was saved, most likely, Module
> 1.
>
> Press Alt-F11 to open the VBE. Right Click on the module, select "Remove
> module..." and say "no" to saving a copy. Save the workbook and you're done
>
> Regards
>
> Trevor
>
>
> "AndersTC" <[email protected]> wrote in message
> news:[email protected]...
> > In Excel I created a makro, which was used to "reorganise" all 12 sheets
> > in
> > the document. After running the makro, the makro was deleted and the
> > document
> > was saved again under a new name.
> > Whenever I now open that particular document I'm asked, if I want the
> > document opened with or without makros.
> > How can this document be "cleaned", so I can open it without that
> > dialog-window about makros?
> >
> >
>
>
>

Dear Trevor

In my first answer to you I wrote that i still had that problem. I have now
tried again and now I succesfully have found that module1 and deleted it and
- wow - it works, so thank you very, very much for your help.

Regards AndersTC

"Trevor Shuttleworth" wrote:

> You need to remove the module where the code was saved, most likely, Module
> 1.
>
> Press Alt-F11 to open the VBE. Right Click on the module, select "Remove
> module..." and say "no" to saving a copy. Save the workbook and you're done
>
> Regards
>
> Trevor
>
>
> "AndersTC" <[email protected]> wrote in message
> news:[email protected]...
> > In Excel I created a makro, which was used to "reorganise" all 12 sheets
> > in
> > the document. After running the makro, the makro was deleted and the
> > document
> > was saved again under a new name.
> > Whenever I now open that particular document I'm asked, if I want the
> > document opened with or without makros.
> > How can this document be "cleaned", so I can open it without that
> > dialog-window about makros?
> >
> >
>
>
>