Delete an autostart Sub with code

[Tempy]

Hi, firstly is it possible to delete an autostart sub routine with code,
if it is possible can you help me with some code.

Les Stout

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Frank Kabel]

Hi
have a look at:
http://www.cpearson.com/excel/vbe.htm

 

[Mark Heyhoe]

Depends what version you are using. You can with 97, but not later.

 

[Tom Ogilvy]

A better thought would be to ask what you are trying to achieve. There may
be a better way.

 

[Tempy]

Thanks Frank

Les Stout

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tempy]

Hi Tom,
Thanks for your reply, as the code i got does not work.

I am recieving a spreadsheet created in Germany and it has auto macro's
in it puting in filters etc...
I save this file after removing the headings and groups to use in acces,
but cannot open the file again as then the data get's all messed up by
the auto macro, so i want to remove the auto macro so that i can open it
without any problem.

Les Stout

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

The simplest soltution would be to
Just have the automacro check the state of the the data. If it has been
processed, then exit the sub, otherwise process the data.