Microsoft KB Archive/71629

{| = Excel: Toggling Menu Items Using a Command Macro =
 * width="100%"|

Last reviewed: November 1, 1994

Article ID: Q71629

SUMMARY
The &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual does not state that the &quot;logical&quot; argument is optional for many macro functions of the type &quot;FUNCTIONNAME(logical)&quot;. Leaving the &quot;logical&quot; argument blank allows the function to be used as a toggle command, rather than specifically stating TRUE or FALSE to toggle the option [which would require knowing the status of the command prior to executing the FUNCTIONNAME(logical) command].

For example, to toggle the menu command Freeze Panes/Unfreeze Panes through a macro, use the following formula:

=FREEZE.PANES This documentation error affects the following functions: A1.R1C1 DATA.FIND ECHO FREEZE.PANES FULL LEGEND PRECISION SHORT.MENUS
 * }