Ah, but type of name is not just a matter of preference with ActiveX
controls !

Regards,
Peter T

"Dave Peterson" wrote in message
...
I don't like spaces in my names, either.

In fact, I'd use:

OLEObj.Name = "Week_" & format(k,"00")

So that they would all look the same (kind of).

Peter T wrote:

Just to add, might be an idea to change

OLEObj.Name = "Week " & k

to
OLEObj.Name = "Week_" & k

IOW, avoid naming ActiveX controls with spaces or punctuation.

Regards,
Peter T
<snip