I want to make a button in my excel sheet, and i write the macro in the microsoft excel objects, Sheet1, where the button is. That doesnt work, but if i write it in Module1, it works.

Why doesnt it work when written in Sheet1. I know this is a very fundamental question which i propably should have been able to find an answer to, but i have now tried, and cant find that information. I'm sorry.

I want several buttons in my "sheet1", and to me it makes sense that i should write the macros for all the buttons which is placed in sheet1, in the corresponding microsoft excel objects.

As you may have figured out, i'm not completely familiar with the different purposes of excel objects and modules.

I have done some VBA coding before, but thats a long time ago now, and i need help to get started.

Thanks