Macro for individuals worksheets

[chrisnsmith]

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?

 

[Khoshravan]

All Macros you create have unique names and they are accessible through all
worksheets.
If you are going to use same Marco in different sheets, you don't need to
record for each sheet. One is enough for all work sheets and under special
circumstances even you can access them from other workbooks (excel files) as
well.

 

[Don Guillett]

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