Microsoft KB Archive/93577

{| = Excel Err Msg: Macro Error at Cell  with ADD.COMMAND =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q93577 The information in this article applies to:
 * Microsoft Excel for Windows, version 4.0.

SUMMARY
In version 4.0 of Microsoft Excel for Windows, you may receive a macro error if you use the ADD.COMMAND function to restore the Save As command to the File menu after removing it with the DELETE.COMMAND function.

This problem occurs if the command_ref argument of the ADD.COMMAND function is entered as &quot;Save As...&quot;. If you specify the command_ref argument as &quot;Save As&quot;, omitting the three periods, the ADD.COMMAND function adds the Save As command to the File menu without error.

For example, use the following line in your macro to restore the Save As Command to the File menu

=ADD.COMMAND(,&quot;File&quot;,&quot;Save As&quot;,7) where  is the number representing the menu bar from which you removed the Save As command.