Makro in Excel

[Guest]

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?

 

[Trevor Shuttleworth]

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

 

[Fredrik Wahlgren]

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

 

[Guest]

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:

 

[Guest]

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