Delete an autostart Sub with code
 

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!

Delete an autostart Sub with code
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tempy wrote:
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!

Delete an autostart Sub with code
 

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

"Tempy" wrote:

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!

Delete an autostart Sub with code
 

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

--
Regards,
Tom Ogilvy

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

Delete an autostart Sub with code
 

Thanks Frank

Les Stout

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

Delete an autostart Sub with code
 

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!

Delete an autostart Sub with code
 

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.

--
Regards,
Tom Ogilvy

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