|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 11th, 2002, 05:05 PM
|
#1 |
|
Board Regular
Join Date: Mar 2002
Posts: 76
|
Can we freeze calculations on one spreadsheet depending on a toggle switch.
My spreadsheets are big and that could save me time when i press f9 in the manual mode. Thanks in advance |
|
|
|
Mar 11th, 2002, 05:07 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Austin, Texas USA
Posts: 11,654
|
Tools | Options... Calculation Manual
|
|
|
|
|
Mar 11th, 2002, 05:22 PM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Posts: 76
|
Manual mode freezes calculation of all sheets. I want to selectively freeze calculations! Liek Sheet1 should update when I press F9 while sheet2 shouldnot.
|
|
|
|
|
Mar 11th, 2002, 05:23 PM
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
Control F9 calculates only the active sheet.
|
|
|
|
|
Mar 11th, 2002, 05:37 PM
|
#5 |
|
Board Regular
Join Date: Mar 2002
Posts: 76
|
can this be done in VBa code. I mean this control f9!
|
|
|
|
|
Mar 11th, 2002, 05:38 PM
|
#6 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
ActiveSheet.Calculate
wasn't that difficult ? |
|
|
|
|
Mar 11th, 2002, 05:47 PM
|
#7 |
|
Board Regular
Join Date: Mar 2002
Posts: 76
|
thanks,
deceptively simple 
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
