The procedure is being called by a 'Change Event' like
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
or
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
these can be found by looking at the visual basic editor and checking the sheet modules for each sheet and the This WorkBook module, thats the only way by clicking a cell the procedure can be run, if its not a Change Event then it could be a Click Event like
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
or
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
look in both modules for these.
Regards,
Simon
Bookmarks