Amending VBA code to refer to another worksheet in another workbook

Hi,

I found something about putting the following code .

Please Login or Register  to view this content.

Then putting wks before Range for the rest of the code as in <code>wks.range</code> but it doesn't work for me.

I'd be grateful if anyone can amend the code in my first post so that it acts on another specific worksheet in another workbook that I want to keep free of VBA.

Thanks,

Paul Carr

StringJazzer . Sorry for the code presentation error. Thanks for making the amendment to my initial post.

I am on a learning curve regarding VBA. My understanding is that I need to set up a class module. What do I put in this class module? Then, I need to amend my original VBA code to read this class module and to properly link to the correct worksheet. How do I do that?

Here's some information I got from reddit.com

You have a problem. You code is event code that has to be in the sheet that it acts on if its going to be triggered by selecting or changing the value of a cell (the two events that you posted.)

The problem is not what sheet the code acts on, the problem is how the code is triggered.

The posted code is triggered by actions on that one sheet. It is scoped to the sheet level. i.e. it runs when cells on that sheet are changed or selected, but only that sheet. It won't trigger if a cell in a different sheet is changed.

It is easy to migrate that to be scoped to the Workbook level, so that the code would be triggered by selecting or changing any cell in the workbook. (Move the code into the ThisWorkbook module). But it won't triggered if a cell in a different workbook is changed.

What you would need to do is migrate that to a Application level event.

<links removed>

The class module that holds the application event can be in the Personal Macro Workbook. And the Personal Macro Workbook's Open event is a good place to put the code that instansizes that class module.