No, not Insert Module, that is a standarde code module, not a sheet code module.

In Excel on your target sheet, right-click the sheet tab, and select VIew Code. Add the code there.