hmm..Im a bit confused about these modules...
as i said im completely new to VB! I will try and explain what I mean in regards to my problem..

When I right click on the command button created..I go to its VB code. This code is displayed within "commandbutton1" and next to it the "click" function is selected.

I have done nothing with the code really...
Excel automatically takes me to the vb code set in the command button 1 when i right click on it.

am i making sense?

I guess Im trying to figure out what the code would be if I wanted to run the macro?