Because the active project in the VB editor is not necessarily the active
workbook in Excel. Think about it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Code Numpty" wrote in message
...
So far so good.
Looks like ActiveWorkbook does the trick better than ActiveVBProject.

I just wish I knew why. Thanks Dave.

"Dave Peterson" wrote:

I'd try:

set vbCom = activeworkbook.VBProject.VBComponents