Worksheet May Be Activated When Method Is Applied

   Application.ScreenUpdating = False
				

MORE INFORMATION

Some methods and properties that are applied to worksheets will cause the worksheet to be briefly activated.

Steps to Reproduce Behavior

1. From the File menu, choose New, and then choose Workbook.
2. From the Insert menu, choose Macro, and then choose Module.
3. In the Visual Basic module, type the following text:

        Sub Protect_Sheet1()
           ActiveWorkbook.Sheets("Sheet1").Protect
        End Sub
   						

4. With the Visual Basic module active, choose Macro from the Tools menu. Select Protect_Sheet1 from the list and choose Run.

The following procedures will also briefly activate the worksheet:

   ActiveWorkbook.Sheets("Sheet1").Unprotect
   ActiveWorkbook.Sheets("Sheet1").Visible = True
				

Some methods or properties, such as the one in the following example, may activate the sheet and cause it to remain the active sheet:

   ActiveWorkbook.Sheets("Sheet1").Move