How to get 1 vba code to run on all sheets in my workbook when active?

[danbates]

Hi,

Please can someone help me?

I would like to run my code via a double click on the activesheet in my workbook.

I know I can put the code in the sheets individually to run but because I have 20 plus sheets I was wondering if there was a way of having just 1 code in a workbook event instead?

Hope this makes sense and any help would be great.

Thanks

Dan

 

[steve the fish]

Right click on ThisWorkbook, view code and use Workbook_SheetBeforeDoubleClick

 

[danbates]

Thanks Steve