Lock or just freeze Page

[jerryjaysr]

Can I run a macro or something so that when I enter data on one page, I can use that data and do some calcuations on another page, then lock the page from ever updating again even though the data page may get updated. Not sure if you'll understand - not sure if I explained it correctly.

[jasoncw]

Here is my interpretation of your request. There is a sheet with formulas, and it allows users to updated it. You want a button that will change the formulas so that they will no longer update, and protect the sheet, so nobody can input to it. Is that accurate? If so:

Create a command button from the Controls toolbox.

Right-click on it, and select View Code.

Copy the following code:

Please Login or Register  to view this content.

Obviously, you will need to change the sheet name above, and you will need to assign your own password to protect the sheet.

HTH

Jason

[jerryjaysr]

Actually, I will be able to use that also but in another sheet. Alot easier than what I had. Thanks - I like it!

I added this to the end:

Application.CutCopyMode = False
Range("a1").Select

But for this page it may be better to be able for me to edit and make changes latter, where this would not let me do that. Would be better (for this page) to just turn off the autocalculations and any cells that get updated (even with text information).

I tried this code and a few I found while doing searches here (which accomplish the same thing)

With Application
.Calculation = xlManual
.MaxChange = 0.001
.CalculateBeforeSave = False
End With
ActiveWorkbook.PrecisionAsDisplayed = False

but only worked when I stayed on that page. What I did to test it was. Run the macro. Go to a new page, cam eback and auto calc turned off, yeah, but when I left and updated that page would be linked to the page that I wanted off, the page retruned back to the auto mode.
Confused yet??