Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autostart Macro | Excel Discussion (Misc queries) | |||
Autostart | Excel Discussion (Misc queries) | |||
Autostart | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
VBA code to delete VBA code in another Workbook | Excel Programming |