macro sets Application.Calculation = xlManual , disables Tools Opt

[Guest]

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]

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).

 

[Guest]

I noticed that most, but not all, of the toolbars were grayed out, in
addition to various menu items, reminiscent of when you are editing a cell
and leave the cursor in the formula bar. Sure enough, my problems were due to
setting the caption of a toggle button in the macro (in addition to turning
calculation off or on) and not selecting something else (like a cell). The
toggle button retained focus, which disabled menu items, tool bars and such.

The macro now selects a cell, which shifts focus to the worksheet again, and
all is well. Thanks for trying to help, Dave.

 

[Dave Peterson]

Thanks for posting back.

Now google has it for the next person who has a similar problem.