What does the macro do?

Tim

--
Tim Williams
Palo Alto, CA


"Paul Riker" <[email protected]> wrote in message
news:[email protected]...
> I have a user that created a spreadsheet containing VBA. Whenever someone
> else opens this spreadsheet and runs the macro it works fine. On his
> computer, he get's this error message:
>
> Microsoft Visual Basic
> Run-time error '1004'
> No cells were found
>
> Sometimes Excel will say "Not Responding". This problem just recently
> started happening. It was working fine before. Eventually, after retrying
and
> retrying the macro will work. He was getting an error before but I don't
know
> if it is related:
>
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 7/26/2005
> Time: 9:38:36 AM
> User: DAVID-TP50145\IWAM_DAVID-TP50145
> Computer: DAVID-TP50145
> Description:
> The application-specific permission settings do not grant Local Activation
> permission for the COM Server application with CLSID
> {0C0A3666-30C9-11D0-8F20-00805F2CD064}
> to the user DAVID-TP50145\IWAM_DAVID-TP50145 SID
> (S-1-5-21-1653462319-2826650621-2974146706-1012). This security
permission
> can be modified using the Component Services administrative tool.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I have since fixed this problem but his Excel issue is still there. Please
> let me know if you can help.
>
> Thanks