Home |
Search |
Today's Posts |
#12
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
this formulas is in English ... what is it in German? | Excel Discussion (Misc queries) | |||
German translation for english formulas | Excel Discussion (Misc queries) | |||
Translate Excel 2000 file from German into English | Excel Discussion (Misc queries) | |||
english equivalent to German formular <ARBEITSTAG? | Excel Discussion (Misc queries) | |||
Sharing worksheets between English and German versions | Excel Discussion (Misc queries) |