Run-time error -2147319784 (80028018) when executing a simple macr

Hello,

I receive run-time error -2147319784 (80028018) when I execute in Excel 2003
a macro that was working before. I get the same error for any macro I try to
record for that file. For exemple, a simple macro that just selects a sheet
or a cell gives that error.

With another file similar macros are working well.

I do not know what is wrong ? Any suggestion please ?

Thank you.

Regards,

Jean-Marc

What have you changed since it was working? Have you added activeX controls
or added userforms. Recall what changes you have made and look there for
problems.

Delete everything in the temp directory and any subdirectories below the
temp directory. Especially any .exd files.

--
Regards,
Tom Ogilvy


"Jean-Marc" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I receive run-time error -2147319784 (80028018) when I execute in Excel
2003
> a macro that was working before. I get the same error for any macro I try
to
> record for that file. For exemple, a simple macro that just selects a
sheet
> or a cell gives that error.
>
> With another file similar macros are working well.
>
> I do not know what is wrong ? Any suggestion please ?
>
> Thank you.
>
> Regards,
>
> Jean-Marc

Tom,

Thanks for your answer.

As far as I remember, I did not change anything ... And even if I record a
new very simple macro in that Excel file it is not working. I always receive
the same error.

I emptied the Temp directory, but it did not change anything.

Any other suggestion ?

Regards,

Jean-Marc


"Tom Ogilvy" wrote:

> What have you changed since it was working? Have you added activeX controls
> or added userforms. Recall what changes you have made and look there for
> problems.
>
> Delete everything in the temp directory and any subdirectories below the
> temp directory. Especially any .exd files.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Jean-Marc" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > I receive run-time error -2147319784 (80028018) when I execute in Excel
> 2003
> > a macro that was working before. I get the same error for any macro I try
> to
> > record for that file. For exemple, a simple macro that just selects a
> sheet
> > or a cell gives that error.
> >
> > With another file similar macros are working well.
> >
> > I do not know what is wrong ? Any suggestion please ?
> >
> > Thank you.
> >
> > Regards,
> >
> > Jean-Marc
>
>
>

Run Rob Bovey's free code cleaner

http://www.appspro.com look for free downloads. Sometimes this will help
when you have peculiar problems. Make a copy of the workbook first. It is
also possible that the file is getting corrupted, so you might want to
consider building a new one.

--
Regards,
Tom Ogilvy


"Jean-Marc" <[email protected]> wrote in message
news:[email protected]...
> Tom,
>
> Thanks for your answer.
>
> As far as I remember, I did not change anything ... And even if I record a
> new very simple macro in that Excel file it is not working. I always
receive
> the same error.
>
> I emptied the Temp directory, but it did not change anything.
>
> Any other suggestion ?
>
> Regards,
>
> Jean-Marc
>
>
> "Tom Ogilvy" wrote:
>
> > What have you changed since it was working? Have you added activeX
controls
> > or added userforms. Recall what changes you have made and look there
for
> > problems.
> >
> > Delete everything in the temp directory and any subdirectories below the
> > temp directory. Especially any .exd files.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Jean-Marc" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello,
> > >
> > > I receive run-time error -2147319784 (80028018) when I execute in
Excel
> > 2003
> > > a macro that was working before. I get the same error for any macro I
try
> > to
> > > record for that file. For exemple, a simple macro that just selects a
> > sheet
> > > or a cell gives that error.
> > >
> > > With another file similar macros are working well.
> > >
> > > I do not know what is wrong ? Any suggestion please ?
> > >
> > > Thank you.
> > >
> > > Regards,
> > >
> > > Jean-Marc
> >
> >
> >