Macros do not work anymore!

When I open an Excel 2ooo worksheet, the Macros do not work anymore!

Needless to say, that the answer was "yes" to the question whether Macros
should be allowed.

Also, no macros are assigned to the buttons I created.

I cannot create new macros, neither on the old worksheet, nor on a new one!

Could it be that the macros were in a Personal.xls file and that file is not
located in the proper directory.
--
Kevin Backmann


"fak119" wrote:

> When I open an Excel 2ooo worksheet, the Macros do not work anymore!
>
> Needless to say, that the answer was "yes" to the question whether Macros
> should be allowed.
>
> Also, no macros are assigned to the buttons I created.
>
> I cannot create new macros, neither on the old worksheet, nor on a new one!

Macro cannot be found! means that you have made an error in the code. Maybe
left off an "End If" in a complex structure.

"fak119" wrote:

> When I open an Excel 2ooo worksheet, the Macros do not work anymore!
>
> Needless to say, that the answer was "yes" to the question whether Macros
> should be allowed.
>
> Also, no macros are assigned to the buttons I created.
>
> I cannot create new macros, neither on the old worksheet, nor on a new one!