maybe the Excel workbook is down rev?
even though the Visual Basic for Applications is checked off in the
'References' section, for some reason maybe it isn't there??
i don't know... it's strange because the code works in my other workbooks.
just not this one.