Update/Refresh Sheet?

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hi
I have a Worksheet_Change event on Sheet 1. I have some cells linked from
Sheet 1 to Sheet 2. I also have a Worksheet_Change event on Sheet 2.
When I add information on Sheet 1 the cells update on sheet 2 but the
Worksheet_Change event for sheet 2 does not run.
(I hope you are following this!)
Is there any way that the Worksheet_Change (on Sheet 2) can be made to run
when the linked cells are changed on sheet 1?
Sandy
 
Worksheet_Change events only fire when an entry is made on the active sheet.
Nothing happens when a calculated value changes on a sheet that is not
active. For example, if you make a change on sheet 1 that changes a
calculation in sheet2, the worksheet change event for sheet 1 only will run.
If you want something to happen to sheet 2 when you change something on
Sheet1, you'll need to add it to you SHeet1 code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run two macros for two different sheets 11
Junp start my Select Case Macro 12
hide multiple worksheets based on a formula value in one cell 1
Excel Run-time error '1004' General ODBC Error 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Problem with sheets that mirror each other 9
Progressive number in different sheets 7

Back
Top