Excel 2000 crashes

[mo]

Im using excel 2000, why when I use countif on the toolbar does excel crash?

 

[kassie]

Can you give an xample?

 

[mo]

I type or click =, I then click the countif button or the arrow leading to
the countif and other choices, the error message then comes up that excel had
encountered a problem and needs to close and excel closes not saving any data
entered.
Can you help?
Mo

 

[Kassie]

Hi Mo,

It sounds like you are using a generated button, driven by a macro? This
certainly is not a standard Excel option.

What happens if you type in you're formula without clicking this
Countifbutton?
If you click on <Alt><F11>, can you see any code to generate a menu item?
If so, clearly something went wrong in the macro, and you'll have to either
repair, or delete it.

 

[mo]

Thanks a lot got it sorted & working ok now thank you