Calling a sub from excel sheet

[satish_j]

I found a excel sub/macro from Internet that allows a single cell contents to be split into multiple rows based on certain character.I copied the code and pasted in a new module window opened from excel(F11 key)
Now,if i go back to worksheet and enter the name of sub in a cell,it says 'That name is not valid'.I guess iam not properly calling the sub.
Can anyone help me how to call a sub from excel sheet?
Thanks..

 

[satish_j]

Thanks..my prob is solved..
Do i have to run this macro everytime from VBE?is there any shortcut so that it can be used from sheets whenever i need it?