Posted to microsoft.public.excel.programming

Bob Phillips[_7_] Bob Phillips[_7_] is offline

external usenet poster

Posts: 1,120

Disable an Autostart module

This will delete a module

Dim vbMod As Object

Set vbMod = ThisWorkbook.VBProject.vbcomponents("Module2")
ThisWorkbook.VBProject.vbcomponents.Remove vbMod

--
HTH

Bob Phillips

"Tempy" wrote in message
...
Hi,

Is it possible to disable/delete an Autostart module with code ?
If this is possible, could you please help me some code.

Thanks

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autostart Macro	McCloudK	Excel Discussion (Misc queries)	5	November 22nd 07 09:38 PM
Autostart	Alias	Excel Discussion (Misc queries)	2	December 8th 05 02:43 AM
Delete an autostart Sub with code	Tempy	Excel Programming	6	June 14th 04 08:20 PM
Autostart	syale	Excel Programming	1	January 29th 04 02:07 AM
Variable from a sheet module in a class module in XL XP	hglamy[_2_]	Excel Programming	2	October 14th 03 05:48 PM

All times are GMT +1. The time now is 12:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us