Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro disables "undo" feature..help please	Terry	Excel Worksheet Functions	6	February 21st 08 04:38 PM
macro to close excel application other than application.quit	mary	Excel Programming	1	September 14th 04 03:43 PM
Application.Calculation	Gareth[_3_]	Excel Programming	2	December 6th 03 01:53 PM
Application Calculation Error	Rick B[_4_]	Excel Programming	2	December 2nd 03 08:49 PM
Application.Calculation exception	Bill Lunney	Excel Programming	0	July 29th 03 04:46 PM

All times are GMT +1. The time now is 07:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us