Calculate active sheet on sheet selection
 

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


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=470781

Calculate active sheet on sheet selection
 

You can use Application.Calculate (or just Calculate)

Check out:
http://msdn.microsoft.com/library/de...HV05199622.asp

Maybe you have to declare it Dirty first:
http://msdn.microsoft.com/library/de...HV03080674.asp

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