I think that there may be other things interfering with your tools|options.

I've never seen this problem in xl2k (or any other version).

Patito wrote:

When I set Application.Calculation=xlManual in a macro, it disables the menu
"Tools Options" selection. Setting Application.Calculation=xlAutomatic does
not re-enable "Tools Options." The HELP files have an example which uses
xlManual, xlAutomatic, yet when you type in the code, the prompts suggest
xlCalculationManual and xlCalculationAutomatic. The problem occurs no matter
what the choice of constant.

This is in Excel 2000. ...anyone know a fix?
Patito

--

Dave Peterson