Calculate active sheet on sheet selection

[a94andwi]

Hello.

I wonder how I manage to do a script that automaticaly recalculates the
current sheet on activation. I have several sheets and I want either of
them to recalculate on activation.

I have a script that copies the sheet name into one cell but it doesn't
want to recalulate when I change to an exact copy of the sheet.

I have turned off automatic calculation but the workbook I'm creating
is for several people that don't know of the F9 button.

Please help. I guess it's quite easy.

/Anders

 

[Remy]

You can use Application.Calculate (or just Calculate)

Check out:
http://msdn.microsoft.com/library/d...s/vbaxl11/html/xlmthCalculate1_HV05199622.asp

Maybe you have to declare it Dirty first:
http://msdn.microsoft.com/library/d.../en-us/vbaxl11/html/xlmthDirty_HV03080674.asp

You can do this in the Workbook_Activate() or Workbook_Open function.