How do I run a custom function only when a worksheet is selected?

Dear Jack,

In this workbook make the calculation option as manual.


then paste this code in the sheet code area,for which upon activation u want to run these function.

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

Thanks for the replies but is there a code that I can put in Module1? I have A LOT of worksheets. But I also tried that in a few sheets, and the function no longer worked if I do it that way. I also tried putting this:

Please Login or Register  to view this content.

...after End Function, but Excel still hangs when I open it.

Let me clarify what I want to do in case there is any misunderstanding.

I have a custom function using Function MyCustomFuction() which is in Modules/Module1. I call this =MyCustomFunction("...") in numerous worksheets and cells. But when I open Excel, Excel seems to execute this function on all the worksheets and Excel freezes. I would like Excel to not execute this function automatically on all sheets and only execute it when I click on a worksheet tab.

This might be what you mean

Please Login or Register  to view this content.

Workbook Event code should be added to the workbook code module:

Copy the Excel VBA code that you want to use
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

Really I would check your Functions - it's not good that they cause this to happen.