Excel: GET.TOOLBAR(9) Function Returns Incomplete Array of IDs

ID: Q93492

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

When you start Microsoft Excel, the docked tool bars are loaded before the floating tool bars. The way these tool bars are loaded may present a problem if you are using an Auto_Open macro that uses the GET.TOOLBAR(9) function. Since the Auto_Open macro may be run before the floating tool bars are loaded, the GET.TOOLBAR(9) function will return an incomplete array of tool bar IDs.

MORE INFORMATION

The GET.TOOLBAR() function is used to return information about one tool bar or all tool bars. GET.TOOLBAR(9) returns an array of tool bar IDs for all visible tool bars.

The GET.TOOLBAR() function may not return a complete array of tool bar IDs if you use it in an Auto_Open macro (a macro that loads automatically when you start Microsoft Excel). The following situations will cause the macro to run before the floating tool bars are loaded, which will result in an incomplete array of tool bar IDs.

Microsoft Excel for the Macintosh and Microsoft Excel for Windows

Placing the sheet containing the Auto_Open macro in the XLSTART subdirectory in Microsoft Excel for Windows or placing it in the Startup Folder in Microsoft Excel for the Macintosh.

Microsoft Excel for Windows

Using an "open=" entry in the EXCEL4.INI (version 4.0) or EXCEL5.INI (version 5.0) to automatically open the sheet containing the Auto_Open macro when you start Microsoft Excel.

-or-

Using an icon command line of "C:\Excel\Excel.exe\filename.xls" Where filename.xls is the file containing the reference to the Auto_Open macro.

Workaround for Microsoft Excel for Windows

To load the floating tool bars before the macro is started, use one of the following methods to start Microsoft Excel:

Create an icon for Microsoft Excel with a command line of "filename.xls", where filename.xls is the file containing the reference to the Auto_Open macro.

From the File menu in Windows File Manager, choose the Run command to start "filename.xls", where filename.xls is the file containing the reference to the Auto_Open macro.

There is no workaround for Microsoft Excel for the Macintosh.

REFERENCES

"Online Help," version 5.0
"Function Reference," version 4.0, pages 206-207

Additional query words: 4.00a 5.0 float tool bar


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 30, 1999