VBA workbook change dosent work on formel. ?? - Need to react on calculation.

[KSveigaard]

Hi All.

Hope you can help again.
I have this code, that works perfectly in active sheet.
BUT, I need the code to react on change in a different worksheet,

So when the change in P3, happens on sheet 2, then in sheet 1, have to hide rows 56:58.
I have tried to enter the code under calculate, with naming the different sheets, can anybody help me.

Please Login or Register  to view this content.

[CK76]

Assuming you have the code in Sheet2 module.
Replace "Sheet1" with actual sheet name of the sheet where you want to hide rows.

Please Login or Register  to view this content.

[MarvinP]

Hi,

See if the attached makes sense. VBA code behind a sheet is supposed to work on that sheet only. You will need to create a module in the "Modules" area to work on any sheet. The topic is called Scope and found at: http://www.cpearson.com/excel/Scope.aspx

Sheet Module vs Module Module.xlsm

[KSveigaard]

Hi,

See if the attached makes sense. VBA code behind a sheet is supposed to work on that sheet only. You will need to create a module in the "Modules" area to work on any sheet. The topic is called Scope and found at: http://www.cpearson.com/excel/Scope.aspx

Attachment 520434

Mr. MarvinP - You are a champ - it works like a charm... I am really happy - Thanks.