Thread: Makro in Excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
AndersTC AndersTC is offline
external usenet poster
 
Posts: 3
Default Makro in Excel

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" wrote in message
...
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?