Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros is several worksheets
Hi all -
When I copy a worksheet, I need to be able to use the same macros for the new sheet. The problem I am having is that when I go to the newly copied sheet, and run the macro, it goes back to the previous sheet. Is there a way to have the macro reference the new sheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros is several worksheets
Is this worksheet one that other people use and need to use the macros as well?
If not, then I would suggest saving the macros on your personal macro file, which means they would be accessable only on that computer. "Lisa" wrote: Hi all - When I copy a worksheet, I need to be able to use the same macros for the new sheet. The problem I am having is that when I go to the newly copied sheet, and run the macro, it goes back to the previous sheet. Is there a way to have the macro reference the new sheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros is several worksheets
yes, this worksheet will be used by other people.
"JasonP CCTM LV" wrote: Is this worksheet one that other people use and need to use the macros as well? If not, then I would suggest saving the macros on your personal macro file, which means they would be accessable only on that computer. "Lisa" wrote: Hi all - When I copy a worksheet, I need to be able to use the same macros for the new sheet. The problem I am having is that when I go to the newly copied sheet, and run the macro, it goes back to the previous sheet. Is there a way to have the macro reference the new sheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros is several worksheets
I'd create a single addin that did the work. Then I'd either place that addin
in a common location (on a network drive that everyone can read) and let the users install the addin. If that's not possible (remote users--or users who are not always connected to the network), then I'd distribute an addin with the instructions that it has to be saved in the same folder on everyone's pc. C:\WorkAddins\LisasUtils.xla By using the same location, it'll make life much easier if workbooks are shared between co-workers. But by creating an addin, I'd have to give the users a way to execute those macros. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm or http://spreadsheetpage.com/index.php...g_custom_menus Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Lisa wrote: Hi all - When I copy a worksheet, I need to be able to use the same macros for the new sheet. The problem I am having is that when I go to the newly copied sheet, and run the macro, it goes back to the previous sheet. Is there a way to have the macro reference the new sheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Macros for All Worksheets in a Workbook? | Excel Worksheet Functions | |||
Macros with Protected Worksheets | Excel Discussion (Misc queries) | |||
Macros and worksheets | Excel Discussion (Misc queries) | |||
macros affecting different worksheets | Excel Discussion (Misc queries) | |||
Unhide Worksheets (hidden via macros) | Excel Discussion (Misc queries) |