VBA application-defined or object-defined error

[Ken Krugh]

Greetings all. We have a shared Excel 2003 file that up to 7 of us access every day, all day, everyone using Excel 2003. This shared workbook opens another work book that has a bunch of macros used by the shared sheet. We have been using this file for YEARS with no issues but recently my computer is generating an "application-defined or object-defined" error with the command to set the position for the comment on a cell. The code looks like this where r is a range passed to a sub routine.

    With r.AddComment
        With .Shape
            .Height = CmtHt
            .Width = CmtWid
            .Placement = xlMoveAndSize
        End With
    End With

My computer is the only one that is having the problem. The only changes to the system that I can think I made was to install the "PDF Maker" portion of Acrobat 9 so I thought that was the problem. However, I've now un-installed that component of Acrobat, "reparied" Microsoft Office, removed and added back in Excel all to no avail.

Again, this worked yesterday, last night I made the change to the system with the Acrobat component, and now only I am getting the error on the .Placement command.

Any help would be greatly appreciated.

All the best,
Ken