Independent SheetX.cells.clear command per sheet

[paradoxofthecat]

Hi, I have a file with 3 Sheets and I created a command button in Sheet1 that will clear all cells in that sheet only using Sheet1.Cells.Clear. How do I replicate that in Sheet 2 and 3 while maintaining the same size of the button for uniformity purposes? Basically, make an independent clear cells command per sheet with the same height and width?

I tried copy pasting the button to sheet2 but I can't find it in VBA where I can just edit it and replace Sheet1.Cells.Clear with Sheet2.Cells.Clear but still being independent from one another.

Help!

[Izandol]

Is it ActiveX button or Forms button?

[paradoxofthecat]

Hi Izandol, I figured it out. Turns out im using Forms instead of an ActiveX command button. Anyway, if Im making around 50 sheets, does it mean I have to individually edit SheetX.Cells.Clear for all those 50 sheets?

[Izandol]

If you do use Forms buttons you may assign same macro to each one:

Please Login or Register  to view this content.