Sheet1 has a macro that activates sheet 4,  other sheets also have macros that activate sheet 4. To control a macro in sheet 4 so that it only runs when Sheet1 activates sheet4, I place the statement Public sheetJobRequestActive As Boolean,
into the routine Public Sub Worksheet_Activate() of sheet1.
I am now getting the error , Invalid attribute in Sub or Function.
Where should I place Public sheetJobRequestActive As Boolean