XL: Worksheet May Be Activated When Method Is Applied

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0

SUMMARY

When you apply methods or change properties of a worksheet, the target worksheet may need to be activated before the macro can perform the requested action. If the worksheet is not already active, a brief flash will be noticeable on the screen when the sheet is activated.

WORKAROUND

To resolve the problem explained in this article, add the following line to the beginning of your Visual Basic for Applications macro:

   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.

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

   ActiveWorkbook.Sheets("Sheet1").Move