Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know Excel has an "On Error" function, but is there such a thing as
On Break or On Reset or On Quit or something of that sort? My code changes Excel's Calculation to Manual and changes it back to Automatic at the end. There's also an On Error function that changes it back to Automatic if there's an error in the code. But sometimes I step through my code and hit Reset, and in this case the Calculation stays in Manual mode. Is there a way I can change it back to Automatic when I hit Ctrl+Break or Reset? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming |