Lot's of ways. As ALWAYS, post YOUR code for comments and suggestions

for each ws in worksheets
ws.do your thing
next

activeworksheet.range("a1")=1


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chrisnsmith" wrote in message
...
I used the macro recorder to create a macro for one of the worksheets in my
workbook, and added a button to my toolbar. My problem is I need
different
macros for each worksheet.

Can I create a macro that will be specific to each worksheet rather than
the
entire workbook?