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?