Working with worksheets between workbook1 and workbook2

%3CLINGO-SUB%20id%3D%22lingo-sub-1783780%22%20slang%3D%22en-US%22%3EWorking%20with%20worksheets%20between%20workbook1%20and%20workbook2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1783780%22%20slang%3D%22en-US%22%3E%3CP%3EOpening%20workbook1%20want%20to%20check%20which%20worksheet%20is%20active%2C%20and%20when%20worksheet%20is%20changed%2C%20set%20its%20name%20to%20ActWsh%20as%20a%20shared%20variable%20between%20the%20two%20workbooks.%20When%20opening%20the%20workbook2%20automatically%20activate%20the%20same%20worksheet%20according%20to%20ActWsh.%20Can%20someone%20please%20help%20me%20please%3F%3F%3F%3F%3C%2FP%3E%3CP%3EThank%20You%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1783780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Opening workbook1 want to check which worksheet is active, and when worksheet is changed, set its name to ActWsh as a shared variable between the two workbooks. When opening the workbook2 automatically activate the same worksheet according to ActWsh. Can someone please help me please????

Thank You

Regards

0 Replies