Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: AutoFormat Method Does Not Work with Macro Modification Security Patch

XL2000: AutoFormat Method Does Not Work with Macro Modification Security Patch

View products that this article applies to.

This article was previously published under Q318474

↑ Back to the top

Symptoms

After you install the Macro Modification Security Update that is described in Microsoft Security Bulletin MS01-50, the AutoFormat method in Microsoft Visual Basic for Applications no longer works.

↑ Back to the top

Resolution

Reinstall the Macro Modification Security Update for Excel 2000 SR-1. This update was re-released on April 25, 2002 to fix this issue.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem is now corrected in the re-released update.

↑ Back to the top

More information

For additional information about the Macro Modification Security Update, click the article number below to view the article in the Microsoft Knowledge Base:
306604 XL2000: Excel 2000 SR-1 Macro Modification Security Update
To determine whether you are experiencing this issue, follow these steps:
1.Start Excel, and type the following values in the default, new workbook:
   A1: Name     B1: Age
   A2: Mary     B2: 15
   A3: Bob      B3: 18
   A4: Ellen    B4: 22
2.On the Tools menu, point to Macro, and then click Visual Basic Editor.
3.In the Visual Basic Editor, click Module on the Insert menu.
4.Type the following code, and then close the Visual Basic Editor:
Sub FormatList()
    Selection.AutoFormat Format:=xlRangeAutoFormatClassic2
End Sub
5.Select one of the cells in your list.
6.On the Tools menu, point to Macro, and then click Macros. Click the FormatList macro, and then click OK.

If your list format changes, this article does not apply to your system.

↑ Back to the top

Keywords: KB318474, kbpending, kboffice2000sp3fix, kboffice2000presp3fix, kbdtacode, kbbug

↑ Back to the top

Article Info
Article ID : 318474
Revision : 6
Created on : 10/10/2006
Published on : 10/10/2006
Exists online : False
Views : 191