Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172920

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:36, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


Article ID: 172920

Article Last Modified on 10/10/2006



APPLIES TO

  • Microsoft Excel 95a
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0a for Macintosh



This article was previously published under Q172920

SYMPTOMS

When you record a macro to toggle the Lock Text check box of an edit box on a dialog sheet, you may receive the following error message when you run te macro:

Run-time error '1000':
EditBox does not have LockedText property

If you click Goto on the Macro Error dialog box, a line similar to the following is selected:

.LockedText = True


CAUSE

Even though Microsoft Excel records the property, there is no LockedText property for the EditBox object in the Microsoft Excel Object Library.

WORKAROUND

You must clear the Lock Text check box for an edit box manually. To do this, follow these steps:

  1. Right-click the edit box.
  2. Click Format Object on the shortcut menu.
  3. On the Protection tab, click to clear the Lock Text check box, and then click OK.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

For additional information, please see the following article in the Microsoft Knowledge Base:

130108 XL Err Msg: Unable to Set the Text Property of Editbox Class



Additional query words: 5.00a 5.00c 7.00a XL5 XL7 XL Err Msg

Keywords: kbbug kberrmsg kbmacro kbprogramming KB172920