Hi Bob

I add it aslo the the last versions of the SendMail Add-ins Bob.
(for the delete VBA code option)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote in message ...
Thanks Ron, one to add to QDE!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Hi Jim

http://www.j-walk.com/ss/excel/tips/tip96.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim McLeod" wrote in message
...
Hi Ron and Bob,

Within the following line of code...
With
ThisWorkbook.VBProject.VBComponents(ExcelWorkSheet .CodeName).CodeModule

I am obtaining the following error...
Run-time error '1004'
Programmic access to Visual Basic Project is not trusted

Any ideas?

Regards,

Jim...