Excel auto calculation Toggling

[ItIsHardToProgram]

I don't know if this problem has been adressed so far, I have searched in the FAQS and on the WEB but I haven't found any hope of fix on this issue.

You probably all know that excel sets the auto calculation or manual calculation depending on the way the first worksheet opened was saved. I thought that putting automatic or manual on the personal worksheet would work, but apparantly not.

Is there a way to make sure a worksheet can't be changed to automatic or manual what ever the settings are on the initial opened worksheet?

I would like to set these settings without using macros considering many users are opening the same worksheets with different settings and not all autorize macros.

If the only fix is a macro, will do, but I would like it to do on open only and on the specific worksheet only, maybe a OnOpen event.

Thank you for your time.


"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.

 

[AnotherHiggins]

-> Is there a way to make sure a worksheet can't be changed to automatic or manual...

???

Maybe I'm dense due to the nearness of the weekend, but I don't understand what you're after.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[ItIsHardToProgram]

Worksheet shouldve been workbook, im also very close to weekend... under an hour...

You can set the cell calculation to automatic or manual, I want the cell calculation to ALWAYS be automatic in Excel...

Unfortunatly, even if u save a workbook as automatic, if you open a manual workbook first, and then a workbook with automatic calculation, its calculation will be set as manual, and unless u toggle it will be saved as manual.

I wish Moffice team would resolve this is issue...

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.

 

[Gavona]

You are trying to beat Excel's built in behaviour. I think that you will only be able to do this with a vba event. So if you are willing to use macros post in forum707.

You say you always want calculation to be automatic - does that include if the workbook was saved while calculation was set to manual?

Gavin

 

[ItIsHardToProgram]

Its what I feared, Yes Gavona, it includes if the workbook was saved while calculation (in another workbook) was set to manual. Basicaly I would like excel to see the 2 workbooks as different instance of excel, if you get where I am going ...

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.

 

[Gavona]

I think that you want an Application WorkbookOpen Event in your Personal.xls file. Probably to detect the current state of calculation and, if manual, ask if you want to change it. Equally a workbook before close event could minimise the risk of saving workbooks with calculation set to manual.

I am no expert - research and then post in forum707 if you want to pursue.

Gavin

 

[docjohn52]

Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic
End Sub


ALT F11, double click "This Worksheet" and drop this in it...

Doesn't matter how it's saved, this will reset it everytime it's opened..

 

[ItIsHardToProgram]

Not as I hoped, but still best I can probably do...



"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.