How to call a macro when clicking in a specific cell from you personal macro workbook?

This is the code I use to call a macro when the macro Im calling is in the same workbook.

Please Login or Register  to view this content.

However, I would like to call this same macro when using another workbook. I copied the macro "Clearformating" and pasted into a personal macro workbook module. However when I add this code to the sheet tab it will not run the macro.

I also tried this code.

Please Login or Register  to view this content.

Thanks in advance!

This works:=

Please Login or Register  to view this content.

Awesome, Thanks so much. I was working in that direction but left out the "Then" part.

Thanks for the help.