How to call userform/sub in Addin from worksheet event

My program which is an addin creates a new worksheet in a workbook. I would like that sheet to be protected so that no data on it can be edited but that double clicking on a cell will displace a userform that is contained within the .xla file.

I can get the prgram to write code to the newly created worksheet (http://www.excelforum.com/showthread.php?t=619171) but have realised a problem. The workbook containing the sheet is a seperate file to the .xla file and therefore if I try and call a sub or ther suerform from the worksheet it is not recognised.

Is there a way to reference procedures in an addin from any workbook?

Hi, sorry for the slow reply, have been on holiday,

I am using the following code, but keep getting the error that the macro can not be found, Is this because there are spaces in the title of the xla file?

Please Login or Register  to view this content.

The sub that calls the form is called ShowForm

Additional information: the project contains two modules, the sub is in a module called "GetGroups" Do I have to reference the module name in order of the program to locate the sub and if so how?

It was due to the spaces in the name, so now have the code to call the form working, thanks Roy