Personal Macro Workbook

[Pestomania]

I currently have very little experience with Personal Macro Workbook (PMW) . I am working with a Macro that monitors a specific cell and activates when the data changes. The macro is nested under that specific sheet rather than a module and it works perfectly. Only problem is, I would like to move that macro to a PMW and have it only monitor that specific sheet. Below is the code.

Private Sub Worksheet_Change(ByVal Target As Range)    If Target.Address = "$C$7" Then        Run resetformatting    End IfEnd Sub

But once this macro is placed into the PMW, it no longer works. How can I make this macro monitor sheet("master") and determine when the cell changes?

 

[Pestomania]

The problem isn't complicated, we're just not communicating.

The computer says, "OK, cell C7 changed on some sheet in some workbook. Should I run the macro?"

What do you tell it?

It says cell C7 changed on Sheet1. Yes, run the macro. The macro will go through and color code the sheets individually based on the cell value. I unfortunately can't type the code out as it is on my work computer. The macro works great, it just needs to know which cell to watch.

 

[shg]

It says cell C7 changed on Sheet1

Any sheet named "Sheet1"?

Every new workbook has a "Sheet1".

 

[Pestomania]

Every workbook will have sheet1 and it will always be named Sheet1.

I'm using sheet1 for simplicity purposes. The true name of that sheet is "Master".

 

[shg]

In ThisWorkbook in Personal:

Dim WithEvents app As Excel.Application

Private Sub Workbook_Open()
  Set app = Application
End Sub

Private Sub app_SheetChange(ByVal Sh As Object, ByVal Target As Range)
  If Sh.Name = "Master" And Target.Address = "$C$7" Then
    ' whatever
  End If
End Sub