Worksheet_SelectionChange Code in one Workbook for Selection in a Different Workbook

Hi all.

I am double-posting this question because I am in dire need of a solution. Here is the link to my other post: http://www.mrexcel.com/forum/showthr...41#post2819941

I have a workbook that contains the following code used to select a sample from another workbook:

Please Login or Register  to view this content.

The code is in WorkbookA but the data to be selected is in WorksheetB.

The code works fine when the data is and the code are in the same workbook but not when they are in different workbooks. It is not possible to have them in the same workbook.

Can anyone help me get it working, please?

Thank you,
Gos-C

Sample workbook?

Hi Tlafferty,

Attached is a sample workbook containg the Worksheet_SelectionChange code. when you move the date to a different workbook the code should execute.

Sorry, I had to make changes to keep it as generic as possible.

Thanks,
Gos-C

I'm gonna go out on a limb here and suggest moving your selection change code to the ThisWorkbook object, and use the Workbook deactivate event like this:

Please Login or Register  to view this content.

Let me know if there's any joy that way...

Do you mean cross posting? If so post the link to the other post!!!!!!!!!!

Hi Tlafferty,

I am not sure what you meant - I noticed that you have Private Sub Workbook_Deactivate() instead of Private Sub Worksheet_SelectionChange(ByVal Target As Range)

I moved the Worksheet_SelectionChange (with the added line If ActiveWorkbook.Name <> ThisWorkbook.Name Then to ThisWorkbook module but it didn't work.

Help!

Hi royUK,

Yes, I meant cross posting. The link is in the first post.

Gos-C

The link didn't show up at home, I'll check it when I get home.

You can't run sheet or workbook event code to act on another workbooks sheet