If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Rename Worksheets From German to English Sheet1
On 07/16/2009 07:27 PM, Dave Peterson wrote:
If I had the same layout in several worksheets (even in several workbooks), I wouldn't duplicate the code in each of the workbooks. I'd create a single workbook (or addin) that contained all the code. Then each time I needed any of the macros, I'd run the code from that workbook with the macros. But the suggestions for doing validity checks still stands. Thank you for all of your help. The workbooks are not in the same location though so using the vba from one workbook is not an option. Regards, -- Wayne glenmeadows.us A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine. [Thomas Jefferson] |
#12
|
|||
|
|||
Rename Worksheets From German to English Sheet1
If you're running the macro against the activesheet, then it doesn't matter
where that file is located--as long as the file is open and the correct worksheet is active. wayne wrote: On 07/16/2009 07:27 PM, Dave Peterson wrote: If I had the same layout in several worksheets (even in several workbooks), I wouldn't duplicate the code in each of the workbooks. I'd create a single workbook (or addin) that contained all the code. Then each time I needed any of the macros, I'd run the code from that workbook with the macros. But the suggestions for doing validity checks still stands. Thank you for all of your help. The workbooks are not in the same location though so using the vba from one workbook is not an option. Regards, -- Wayne glenmeadows.us A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine. [Thomas Jefferson] -- Dave Peterson |
|
Thread Tools | |
Display Modes | |
|
|