calling an event macro from a different workbook

Hi,

I currently have a macro that opens a workbook in a directory then formats it accordingly. My question is, I want to add a Worksheet_SelectionChange function into Sheet1 of that newly opened workbook to highlight the entire row of the selected cell when the user looks at it. How can I call this in the original macro that opened the workbook? The workbook is a report of some sort and the users need to switch to another program for research as they work through the entire report. It would be a nice feature to have the row highlighted to indicate which account is currently being worked on. Thanks in advance!

Please Login or Register  to view this content.

Hi cwchan220,

In the original workbook, try code like the following:

Please Login or Register  to view this content.

'Book1', 'Sheet1', and 'F9' refer to the Workbook just opened.

Lewis

Are you referring to the original workbook that has the macro that opens the workbook from the directory?

I might not be explaining thoroughly. Right now, I have a Master workbook that stores the macros to open various reports from a folder. (These reports are updated/overwritten from the server daily so I can't store the macro directly in them.) The macro runs when the user clicks on a button in the Master workbook. After the report opens (in a different workbook), I want Sheet1 on the Report workbook to highlight the entire row of the cell when the user selects it. As the user works on the report, they will select another cell to highlight that row and so on. I am able to get my code to work when I put it in after the Report workbook opens but how do I add it into Sheet1 from the original macro in the Master workbook? Hope that clarifies.

I am getting a compile error: User-defined type not defined on the new module with "sh as sheethandler" highlighted and the below in red.

Please Login or Register  to view this content.

That got rid of the red but still getting the same error with "sh as sheethandler" highlighted

Worked like a charm! My first Class Module. All your help is very much appreciated!

I'm not sure if I should create a new thread for this but I noticed if I open a second Report Workbook, the highlighting stops working for the first one. Is there a workaround for this so that the highlighting works for all the reports that are open?