Removing code in 'This Workbook'
 

I am using Excel 97.

I am wanting to progammatically remove the code in the 'This workbook' module.

Can anyone assist with some code please?

Thanks

--
Mark

Removing code in 'This Workbook'
 

Hi Mark,

See topic "Deleting All Code From A Module" from Chip Pearson's Site

http://www.cpearson.com/excel/vbe.htm



Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


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

Removing code in 'This Workbook'
 

Sub Rid()
With ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule
.DeleteLines 1, .CountOfLines
End With
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark" wrote in message
...
I am using Excel 97.

I am wanting to progammatically remove the code in the 'This workbook'
module.

Can anyone assist with some code please?

Thanks

--
Mark