Run macro on double click - several macros on one worksheet

Hi, I am fairly new at this so would appreciate any advice!

I have several macros written that open other workbooks. I have a "front page" worksheet with a list of these workbooks. I would like to be able to double click the name of the workbook and have it run the macro to open it.

I have gone into the code for this worksheet and have a private sub before double click. I then used "case" to state that if a certain cell was doubled clicked, then call the macro to open that workbook:

Please Login or Register  to view this content.

My workbook open macros are working but the double click procedure isn't. Can anyone shed any light on why please? Or help me find a better way to do it?

Thank you in advance.

It's ok, I solved it!

Please Login or Register  to view this content.