Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for individuals worksheets
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for individuals worksheets
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. "chrisnsmith" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for individuals worksheets
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email workbook to multiple individuals with their specific data | Excel Discussion (Misc queries) | |||
the curser is highlighting multiple cells instead of individuals | Excel Discussion (Misc queries) | |||
What formula do I use to get individuals ages from their birthday | Excel Discussion (Misc queries) | |||
Work out overtime hours for individuals | New Users to Excel | |||
Work out overtime hours for individuals | New Users to Excel |