how do I create a macro for 2 sheets

N

Niels

I have a workbook with 2 sheets. On sheet 2 I have created a button to clear
the content of sheet 1 using a macro.
Sheets("Sheet1").Select
Columns("A:B").Select
Selection.ClearContents

When I run the macro it works but when I use the button it doesn't. What is
wrong??
 
Top