Hit Alt+F11, double-click 'ThisWorkbook' and paste into the window that
opens. Save, Close, Open. Should have mentioned it before.

To turn "off":
Application.Calculation = xlCalculationManual

To turn "on":
Application.Calculation = xlCalculationAutomatic

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Peter" wrote:

I opened Developer and pasted it in under VBA but it does not do
anything....I am ignorant as to how to get subroutines to run....

"ryguy7272" wrote:

You will need VBA:
http://www.decisionmodels.com/calcsecretsh.htm

Something like this should work:
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Peter" wrote:

I'm a teacher and want to create a worksheet form where students can enter
answers to (their handwritten) math problems.

For the student's version of the answer spreadsheet, I want all Excel
functions shut off, so that students cannot use Excel to calculate their
answers. All my students have PCs they can bring into class so that they
could get their versions of the file off a shared server.

I could then speed up grading hundreds of questions by having my own version
of the spreadsheet with True/False getting pasted back alongside each
student's answers in each of their versions, for their feedback.

The Calculation Options tab under Formulas in Office 2007 Excel does not
seem to give the option of shutting everything off. All I want them to have
is data entry capability.

Thanks!
- Peter