How do I cause my macro to 'auto-update' whenever linked cells are updated??

**Scottie in BKK** · 10-06-2012, 04:42 PM

On the attached spreadsheet I have an example of what I would like to occur..

I have two sheets

View Only
Data Entry

I would like to update the data on the Data Entry Sheet (which is linked to update the cells on the "View Only" sheet) & have the Macro auto run to hide the columns as programs in the VBA.

Cell C2 on the 'Data Entry' Sheet provides the data update to Cell A1 on the 'View Only' Sheet

Cell C4 on the 'Data Entry' Sheet provides the data update to Cell A11 on the 'View Only' Sheet

At the moment cells A1 & A11 update with their actual value however the Macro does not activate to cause the rows to become hidden...

Is it possible to cause a Macro to Auto-Update/Refresh whenever the Cells A1 & A11 update info from their corresponding cells?

Online Test.xlsm

**Bishonen** · 10-06-2012, 05:04 PM

why don't you just put this code in sheet 2 instead?

Please Login or Register  to view this content.

The cells in the first sheet don't change - they still have the same formula in them. The fact that what those return changes doesn't triger the change event.

**Scottie in BKK** · 10-06-2012, 05:05 PM

Thanks... is that also possible to be done if the second sheet is on another file?

**Bishonen** · 10-06-2012, 05:26 PM

Pretty sure yes - the needed code goes to the worksheet which will change. And you must make sure to point to the appropriate workbook+sheet to make the hide/unhide.