Microsoft KB Archive/259607

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

Article ID: 259607

Article Last Modified on 6/26/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



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.



Steps to Reproduce the Behavior
 Open Microsoft Excel. Edit and save the current worksheet. Press ALT+F11 to open the Visual Basic Editor. 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.

 On the Add-ins menu, point to VBA Source Code Control, and then click Check Out.</li> In the Properties window of the Visual Basic Editor, change the Name property by adding a character to the end of the current name.</li> 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.

</li> 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.</li> 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.</li></ol>

Additional query words: pra VBE VBA

Keywords: kbbug kbpending KB259607

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.