Chip Pearson wrote:

Steven,

See www.cpearson.com/excel/vbe.htm for details and example code.

Chip,

If McAfee VirusScan ASaP is installed, this won't work.
McAfee is very effective at zapping the entire code module when you
have a line of code that changes the VBA project. More precisely,
McAfee considers the following methods as possible viral actions:

VBComponents.Add
VBComponents.Remove
VBComponents.Import
CodeModule.InsertLines
CodeModule.DeleteLines

I don't know about other McAfee products or AV products from other
companies, but I think a precautionary warning on your website might be
appropriate.

--
Amedee Van Gasse
To top-post is human, to bottom-post and snip is sublime.