don't feel dumb - & plus you might have just helped somebody out of a
future nightmare! :)
thanks!
susan


On Jul 6, 9:35 am, "blackbox via OfficeKB.com" <u20390@uwe wrote:
felt kinda dumb when I figured it out.

in cell D12 "Yes" was upper case and in the code it was lower case...

also

vbCom.Remove VBComponent:= _
vbCom.Item("Module1")
vbCom.Item ("Module2")

only deleted Module1

changed it to

vbCom.Remove VBComponent:= _
vbCom.Item("Module1")

vbCom.Remove VBComponent:= _
vbCom.Item ("Module2")

Susan wrote:
what was the problem? interesting idea.................
thanks
susan

never mind, I figured it out

[quoted text clipped - 40 lines]

- Show quoted text -

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200707/1