Thread: macro sets Application.Calculation = xlManual , disables Tools Opt
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patito Patito is offline
external usenet poster
  
Posts: 3
Default macro sets Application.Calculation = xlManual , disables Tools Opt
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
Reply With QuoteReply With Quote