MOD2000: Excel Objects in Visual Basic Editor Lose Connectivity to Visual SourceSafe When You Rename The Objects (259607)


The information in this article applies to:

  • Microsoft Office 2000 Developer
This article was previously published under Q259607

SYMPTOMS

If you rename a Microsoft Excel worksheet or VBA project that you have placed under Microsoft Visual SourceSafe control, the object is removed from source code control. When you try to check the object back into Visual SourceSafe after you rename the object, you receive the following error message:
You do not have any files checked out from Source Code Control.
If you rename the object back to its original name, Visual SourceSafe control is reinstated over the object.

RESOLUTION

If you must rename an object that is currently under Visual SourceSafe control, first remove the object from the Visual SourceSafe database. After you have renamed the object, check the object back into Visual SourceSafe under its new name.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open Microsoft Excel.
  2. Edit and save the current worksheet.
  3. Press ALT+F11 to open the Visual Basic Editor.
  4. On the Add-ins menu, point to VBA Source Code Control, and then click Add Project to SourceSafe. As the project is checked in, accept all defaults.

    For more information about adding add-ins, click Microsoft Excel Help on the Help menu, type add-ins manager in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
  5. On the Add-ins menu, point to VBA Source Code Control, and then click Check Out.
  6. In the Properties window of the Visual Basic Editor, change the Name property by adding a character to the end of the current name.
  7. On the Add-ins menu, point to VBA Source Code Control, and then click Check In. Note that you receive the following error message:
    You do not have any files checked out from Source Code Control.
  8. In the Properties window of the Visual Basic Editor, change the Name property by removing the character at the end of the current name that you added in step 6.
  9. On the Add-ins menu, point to VBA Source Code Control, and then click Check In. Note that the object is checked in as expected.
Modification Type:MajorLast Reviewed:6/26/2001
Keywords:kbbug KB259607
©2002 Microsoft Corporation. All rights reserved.