Microsoft KB Archive/167178

From BetaArchive Wiki
Knowledge Base


XL97: Some Properties and Methods Are Missing in Object Browser

Article ID: 167178

Article Last Modified on 10/11/2006



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q167178


SUMMARY

Some methods and properties do not appear in the Object Browser in Microsoft Excel 97.

MORE INFORMATION

These methods and properties are not missing; they are hidden. They are hidden because new methods and properties replace them in Microsoft Excel. The hidden methods and properties remain in the Object Browser for backward compatibility only.

To view hidden methods and properties in the Object Browser in Microsoft Excel 97, do the following:

  1. Open the Visual Basic Editor (Press ALT+F11).
  2. On the View menu, click Object Browser (or press F2).
  3. Right-click the Object Browser and click Show Hidden Members on the shortcut menu.


Anything that is hidden is displayed in a light gray font.

NOTE: When you are writing new macros, Microsoft recommends that you use the new functionality in Microsoft Excel 97 instead of using earlier functionality provided by the hidden methods and properties.

REFERENCES

For more information about hidden properties and methods, do the following:

  1. In the Object Browser, click "<globals>" in the Classes list.
  2. In the Members Of list, right-click the first hidden member (this should be ActiveDialog), and click Help on the shortcut menu.
  3. Click "Hidden Properties and Methods."



Additional query words: XL97 missing xlvbmigrate

Keywords: kbinfo KB167178