How to Locate Macro

[spectraflame]

We have a spreadsheet that contains a macro that each time you select one of the tabs of the workbook, the macro checks to see if the sheet is protected. If it is not, it protects it. I have looked through each of the Modules as well as the code for each worksheet within the workbook. I know the name of the macro and think it is some how tied to the OnSheetActive trigger but I cannot find it.

Any suggestions?

 

[Peter_SSs]

Have a look in the ThisWorkbook module.

 

[spectraflame]

I find nothing under the General or Workbook selections either.

 

[spectraflame]

Think I found it. This was hidden in the middle of some other macros.

Sub Autpen()
Application.OnSheetActivate = "UpdateIt"
End Sub

After commenting these lines out, I think that took care of the issue.